{
  "name": "mtf.trading bulk export API",
  "endpoint": "/api/v1/export",
  "description": "Bulk historical exports of mtf.trading's official-source datasets. All money columns are in Rs crore. Query one bundle as JSON or CSV, or download the gzipped bundle directly from /exports/, or everything at once as a zip.",
  "unit": "INR_crore",
  "license": "CC BY 4.0 - free to use with attribution to mtf.trading",
  "generated": "2026-10-08T17:05:22Z",
  "params": {
    "dataset": "bundle id (see datasets below). Required to return rows.",
    "format": "json (default) | csv",
    "limit": "default 500, max 200000",
    "offset": "row offset for paging",
    "fields": "comma-separated column subset"
  },
  "datasets": [
    {
      "id": "daily_totals",
      "title": "Daily MTF totals (NSE + BSE)",
      "description": "Per-exchange daily outstanding margin-funded book, fresh exposure and liquidation since 22 Jun 2017.",
      "rows": 4153,
      "coverage": {
        "from": "2017-06-22",
        "to": "2026-10-07"
      },
      "columns": [
        "date",
        "exchange",
        "beginning_outstanding_cr",
        "fresh_exposure_cr",
        "exposure_liquidated_cr",
        "end_outstanding_cr",
        "securities_count"
      ],
      "source": "NSE and BSE daily MTF disclosures",
      "download_gz": "/exports/daily_totals.csv.gz",
      "api": "/api/v1/export?dataset=daily_totals&format=csv",
      "source_json": "/mtf_daily_totals.json"
    },
    {
      "id": "flow_daily",
      "title": "Leverage flow (daily)",
      "description": "Daily fresh vs liquidated exposure, net flow, churn and end-of-day book.",
      "rows": 2205,
      "coverage": {
        "from": "2017-06-22",
        "to": "2026-10-07"
      },
      "columns": [
        "date",
        "fresh_cr",
        "liquidated_cr",
        "net_cr",
        "churn",
        "end_outstanding_cr"
      ],
      "source": "Derived from NSE/BSE daily MTF disclosures",
      "download_gz": "/exports/flow_daily.csv.gz",
      "api": "/api/v1/export?dataset=flow_daily&format=csv",
      "source_json": "/mtf_flow.json"
    },
    {
      "id": "flush_events",
      "title": "Margin flush events",
      "description": "Large single-day net liquidation episodes with severity and context label.",
      "rows": 25,
      "coverage": {
        "from": "2024-05-21",
        "to": "2026-05-06"
      },
      "columns": [
        "date",
        "net_cr",
        "liquidated_cr",
        "book_cr",
        "severity",
        "label"
      ],
      "source": "Derived from NSE/BSE daily MTF disclosures",
      "download_gz": "/exports/flush_events.csv.gz",
      "api": "/api/v1/export?dataset=flush_events&format=csv",
      "source_json": "/mtf_flow.json"
    },
    {
      "id": "turnover_daily",
      "title": "Daily traded value (cash + F&O)",
      "description": "Daily NSE/BSE cash and F&O notional turnover in Rs crore since 22 Jun 2017.",
      "rows": 2295,
      "coverage": {
        "from": "2017-06-22",
        "to": "2026-10-08"
      },
      "columns": [
        "date",
        "nse_cash_cr",
        "nse_fo_cr",
        "bse_cash_cr",
        "bse_fo_cr"
      ],
      "source": "NSE and BSE daily market reports",
      "download_gz": "/exports/turnover_daily.csv.gz",
      "api": "/api/v1/export?dataset=turnover_daily&format=csv",
      "source_json": "/mtf_turnover_daily.json"
    },
    {
      "id": "brokers_history",
      "title": "Per-broker MTF book history",
      "description": "Every disclosed broker MTF book point from exchange disclosures, results, annual reports and credit ratings. Net points are tagged basis=net.",
      "rows": 17378,
      "coverage": {
        "from": "2017-02-01",
        "to": "2026-09-30"
      },
      "columns": [
        "broker_id",
        "broker_name",
        "type",
        "tier",
        "period",
        "mtf_book_cr",
        "basis",
        "net_worth_cr",
        "gearing",
        "nse_mtf_cr",
        "nse_clients",
        "source_type",
        "confidence",
        "source",
        "source_url"
      ],
      "source": "Exchange disclosures, broker results/annual reports, credit-rating rationales",
      "download_gz": "/exports/brokers_history.csv.gz",
      "api": "/api/v1/export?dataset=brokers_history&format=csv",
      "source_json": "/brokers.json"
    },
    {
      "id": "stock_latest",
      "title": "Stock universe (latest snapshot)",
      "description": "Latest per-stock MTF book, market cap, free-float market cap and leverage for the whole MTF-funded universe.",
      "rows": 3475,
      "coverage": {
        "from": "2017-07-05",
        "to": "2026-10-07"
      },
      "columns": [
        "symbol",
        "name",
        "exchange",
        "isin",
        "as_of_date",
        "mtf_book_cr",
        "qty_financed",
        "avg_price_inr",
        "mcap_cr",
        "ffmc_cr",
        "combined_book_cr",
        "leverage_pct",
        "ff_leverage_pct",
        "change_30d_pct",
        "adv",
        "days_to_cover",
        "is_etf"
      ],
      "source": "NSE/BSE MTF stock disclosures + BSE market caps",
      "download_gz": "/exports/stock_latest.csv.gz",
      "api": "/api/v1/export?dataset=stock_latest&format=csv",
      "source_json": "/compressed_data/screener_data.json"
    },
    {
      "id": "surveillance",
      "title": "Surveillance flags (snapshot)",
      "description": "Current ASM/GSM/ESM/IBC/ban flags and severity by ISIN, with curated risk triggers.",
      "rows": 1722,
      "coverage": {
        "from": "2026-10-08",
        "to": "2026-10-08"
      },
      "columns": [
        "isin",
        "symbol",
        "exchanges",
        "severity",
        "label",
        "gsm",
        "asm",
        "st_asm",
        "esm",
        "ibc",
        "ica",
        "ban",
        "risk_flags"
      ],
      "source": "NSE/BSE surveillance circulars",
      "download_gz": "/exports/surveillance.csv.gz",
      "api": "/api/v1/export?dataset=surveillance&format=csv",
      "source_json": "/surveillance.json"
    },
    {
      "id": "pledge_history",
      "title": "Promoter pledge history",
      "description": "Quarterly promoter-pledge percentage by stock.",
      "rows": 3311,
      "coverage": {
        "from": "2025-01",
        "to": "2026-08"
      },
      "columns": [
        "symbol",
        "isin",
        "source",
        "quarter",
        "pledge_pct_of_promoter"
      ],
      "source": "NSE/BSE shareholding-pattern (pledge) filings",
      "download_gz": "/exports/pledge_history.csv.gz",
      "api": "/api/v1/export?dataset=pledge_history&format=csv",
      "source_json": "/pledge_history.json"
    }
  ],
  "download_all_zip": "/exports/mtf_full_export.zip",
  "manifest": "/exports/index.json",
  "docs": "https://mtf.trading/data"
}