{"catalog_version":1,"view":"app_detail","app":"mf","app_title":"MFPRO","status":"ok","generated_at":"2026-10-25T02:27:05Z","summary_url":"https://api.tigzig.com/downloads","source_index_url":"https://mfpro.tigzig.com/data/exports/data-catalog.json","query_in_place":{"http_range_requests":true,"formats":["parquet"],"how":"Parquet files support HTTP range requests, so DuckDB, pyarrow, polars or a browser can query them in place and read only the parts a query needs.","example_sql":"SELECT count(*) FROM read_parquet('https://api.tigzig.com/mf/v1/download/amfi_nav_master.parquet');","example_curl":"curl -H \"Range: bytes=-8\" https://api.tigzig.com/mf/v1/download/amfi_nav_master.parquet","limits":"Range reads have their own per-IP budget, separate from whole-file downloads. Every response carries X-RateLimit headers."},"datasets":[{"id":"mf.portfolio_holdings","title":"Mutual fund portfolio holdings / composition (selected equity funds)","description":"Monthly portfolio holdings of 24 Indian equity mutual funds across large cap, mid cap, small cap, flexi cap, focused and value categories, as disclosed by the fund houses. Quarter-ends June, September and December 2025, then every month from January 2026 (July, August, October and November 2025 are not loaded). One row per line of the fund house file per month-end, so a fund-month can have several rows under one isin where lines are grouped. Every fund-month adds up to the fund house's own grand total (net assets), apart from two PPFAS months where the file's typed grand total differs from its own section sub-totals (see the validation page). asset_group and asset_subgroup classify each line (equity, foreign stocks, cash, money market, mutual fund units, REITs and InvITs, debt, others). Codes starting SYN and IN9999999999 are placeholders for grouped lines (TREPS, a fund house cash line, CDs, CPs, T-bills, G-secs, receivables and margins); codes starting DUM are shares awaiting listing. asset_subgroup marks shares awaiting listing (IPO allotments and newly demerged companies) for the months before they list, whether they carry a DUM code or their final ISIN. Each fund house values them itself, so the value can differ between fund houses until they list. Futures that a fund house lists after its grand total are outside its net assets and are not in this file. There is no sector column.","category":"funds","kind":"tool_export","publisher":"Fund houses (monthly portfolio disclosures); ISIN reference from NSDL and NSE","coverage":"2025-06-30 to 2026-09-30 (12 month-ends)","data_as_of":"2026-09-30","update_cadence":"monthly","row_count":22236,"tool_url":"https://www.tigzig.com/mfpro/composition","docs_url":"https://www.tigzig.com/mfpro/composition-methodology","methodology_url":"https://www.tigzig.com/mfpro/composition-methodology","validation_url":"https://www.tigzig.com/mfpro/composition-validation","tags":["mutual funds","india","portfolio holdings","equity","isin"],"columns":[{"name":"fund_code","description":"Short fund code used in MFPRO, e.g. HDFCFLEXICAP"},{"name":"fund_name","description":"Fund name"},{"name":"fund_category","description":"Fund category as grouped in MFPRO: largecap, midcap, smallcap, flexicap, focused, value (value holds ICICI Prudential Value and SBI Contra; AMFI lists SBI Contra under Contra)"},{"name":"month_end","description":"Portfolio date: the month-end the fund house disclosed, ISO date"},{"name":"isin","description":"ISIN used for grouping. Same as isin_as_filed except where a mapping applies (see mapping_category). Not unique within a fund-month: several rows can share one isin (grouped lines such as TREPS, T-bills and receivables). Sum market_value_lakh by fund_code, month_end and isin before joining on it"},{"name":"security_name","description":"Security name used for display, matched to the ISIN"},{"name":"nse_symbol","description":"NSE trading symbol where the security is listed on NSE, else empty"},{"name":"market_value_lakh","description":"Market value of the holding at month-end, in Rs lakh, as filed by the fund house, rounded to 5 decimals (to the rupee)"},{"name":"quantity","description":"Number of shares or units held, as filed"},{"name":"pct_of_fund","description":"Holding as a percent of the sum of market_value_lakh for that fund and month, rounded to 4 decimals"},{"name":"asset_group","description":"Equity, Foreign stocks, Cash, Money market, Mutual fund units, REITs and InvITs, Debt or Others. Cash = TREPS, triparty repo, reverse repo and a fund house cash line; Money market = T-bills, CDs, CPs; Debt = G-secs and corporate bonds; Others = net receivables and payables, net current assets, margins, options, and futures where the fund house lists them inside its net assets (Axis, Motilal Oswal). Futures listed after a fund house grand total are outside its net assets and are not in this file"},{"name":"asset_subgroup","description":"Finer split inside asset_group, e.g. Listed shares, Preference shares, Partly paid shares, Shares awaiting listing, Convertible debentures, TREPS and triparty repo, Treasury bills, Certificates of deposit, Commercial paper, Government securities, Margins, Futures, Options, Net receivables, payables and current assets"},{"name":"mapping_category","description":"Empty for an ordinary holding. Otherwise why the ISIN was mapped: CORPORATE_ACTION, CD_AGGREGATE, CP_AGGREGATE, TBILL_AGGREGATE, GSEC_AGGREGATE, TREPS_AGGREGATE, CASH_LINE, OTHERS_AGGREGATE (called CASH_AGGREGATE before October 2026), FOREIGN_STOCK"},{"name":"mapping_reason","description":"Plain reason for the mapping, empty for an ordinary holding"},{"name":"isin_as_filed","description":"ISIN exactly as it appears in the fund house file (some lines, such as cash, carry none)"},{"name":"instrument_name_as_filed","description":"Instrument name exactly as it appears in the fund house file, including its footnote markers (for example HDFC marks its sponsor bank with £, other houses use ** or @@). security_name is the clean name"}],"files":[{"format":"csv","label":"CSV","role":"data","url":"https://api.tigzig.com/downloads/mf_portfolio_holdings.csv","size_bytes":4573219,"sha256":"8f8d785db0ad59717211f6c109a1f355985cc65b7b9aadd68412125eaad66481","row_count":22236,"generated_at":"2026-10-24T15:01:08Z"},{"format":"csv","label":"Column dictionary","role":"dictionary","url":"https://api.tigzig.com/downloads/mf_portfolio_holdings_columns.csv","size_bytes":2673,"sha256":"32d79d723a91bffd38899e20352a7275f134de92e98d01404127781da289bcaa","row_count":16,"generated_at":"2026-10-24T15:01:08Z"}],"app":"mf"},{"kind":"bulk_download","publisher":"AMFI (Association of Mutual Funds in India)","docs_url":"https://www.tigzig.com/apis/mf-nav","slice":false,"id":"mf.data_quality","table":"data_quality","title":"Scheme details: rows that could not be matched cleanly","description":"The rows where AMFI's daily feed and the scheme documents could not be matched cleanly, with the reason for each.","category":"funds","update_cadence":"4x daily","tags":["mutual funds","data quality"],"app":"mf","files":[{"format":"csv","label":"CSV","role":"data","url":"https://api.tigzig.com/mf/v1/download/data_quality.csv","size_bytes":165288,"generated_at":"2026-10-24T23:45:14Z","row_count":571},{"format":"json","label":"JSON","role":"data","url":"https://api.tigzig.com/mf/v1/download/data_quality.json","size_bytes":228411,"generated_at":"2026-10-24T23:45:14Z","row_count":571}],"methodology_url":"https://www.tigzig.com/mfpro/how-the-data-is-built","tool_url":"https://mfpro.tigzig.com/dashboard#quality/validations","validation_url":"https://mfpro.tigzig.com/dashboard#quality/validations","row_count":571,"data_as_of":"2026-10-22"},{"kind":"bulk_download","publisher":"AMFI (Association of Mutual Funds in India)","docs_url":"https://www.tigzig.com/apis/mf-nav","slice":false,"id":"mf.nav_history","table":"nav_history","title":"NAV history, every scheme, every day","description":"One row per scheme per date, April 2006 to today, for every scheme in AMFI's records including matured and merged ones. Specialized Investment Funds (SIF) are included after the mutual funds; the last column, source, says which.","category":"funds","update_cadence":"3x daily","tags":["mutual funds","nav","india","amfi","time series"],"app":"mf","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.csv.gz","size_bytes":232238049,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.csv.zip","size_bytes":251632156,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.parquet","size_bytes":178436515,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479,"http_range_requests":true},{"format":"tsv.gz","label":"TSV.gz","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.tsv.gz","size_bytes":231774492,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479},{"format":"tsv.zip","label":"TSV.zip","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.tsv.zip","size_bytes":251353695,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479},{"format":"sqlite.zip","label":"SQLite.zip","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.db.zip","size_bytes":1466893705,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479},{"format":"sqlite.gz","label":"SQLite.gz","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master.db.gz","size_bytes":1466893549,"generated_at":"2026-10-24T18:40:25Z","row_count":37648479}],"methodology_url":"https://www.tigzig.com/mfpro/how-the-data-is-built","tool_url":"https://mfpro.tigzig.com/dashboard#returns","validation_url":"https://mfpro.tigzig.com/dashboard#quality/validations","row_count":37648479,"data_as_of":"2026-10-25"},{"kind":"bulk_download","publisher":"AMFI (Association of Mutual Funds in India)","docs_url":"https://www.tigzig.com/apis/mf-nav","slice":false,"id":"mf.nav_latest","table":"nav_latest","title":"Scheme universe with latest NAV","description":"One row per scheme: scheme master (both ISINs, AMC, category, plan, option), first and last NAV dates, the latest NAV and average AUM. Specialized Investment Funds (SIF) are included after the mutual funds; the last column, source, says which.","category":"funds","update_cadence":"3x daily","tags":["mutual funds","nav","scheme master","aum"],"app":"mf","files":[{"format":"csv","label":"CSV","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master_latest.csv","size_bytes":10096881,"generated_at":"2026-10-24T18:40:25Z","row_count":38463},{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master_latest.csv.gz","size_bytes":1192819,"generated_at":"2026-10-24T18:40:25Z","row_count":38463},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master_latest.csv.zip","size_bytes":1192951,"generated_at":"2026-10-24T18:40:25Z","row_count":38463},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/mf/v1/download/amfi_nav_master_latest.parquet","size_bytes":1645052,"generated_at":"2026-10-24T18:40:25Z","row_count":38463,"http_range_requests":true}],"methodology_url":"https://www.tigzig.com/mfpro/how-the-data-is-built","tool_url":"https://mfpro.tigzig.com/dashboard#returns","validation_url":"https://mfpro.tigzig.com/dashboard#quality/validations","row_count":38463,"data_as_of":"2026-10-25"},{"kind":"bulk_download","publisher":"AMFI (Association of Mutual Funds in India)","docs_url":"https://www.tigzig.com/apis/mf-nav","slice":false,"id":"mf.scheme_details_latest","table":"scheme_details_latest","title":"Scheme details: fund size, scheme document, expense ratio","description":"One row per scheme: AMFI daily fund size, riskometers, benchmark, the scheme summary document (fund managers, dates, objective, exit load) and the latest TER. Fund-level columns repeat on every plan, so total fund size only where fund_dedup_flag is true. Specialized Investment Funds (SIF) are included after the mutual funds; the last column, source, says which.","category":"funds","update_cadence":"4x daily","tags":["mutual funds","aum","ter","fund managers","riskometer"],"app":"mf","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/mf/v1/download/scheme_details_latest.csv.gz","size_bytes":2863941,"generated_at":"2026-10-24T23:45:14Z","row_count":11384},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/mf/v1/download/scheme_details_latest.parquet","size_bytes":1286952,"generated_at":"2026-10-24T23:45:14Z","row_count":11384,"http_range_requests":true}],"methodology_url":"https://www.tigzig.com/mfpro/how-the-data-is-built","tool_url":"https://mfpro.tigzig.com/dashboard#returns/fund","validation_url":"https://mfpro.tigzig.com/dashboard#quality/validations","row_count":11384,"data_as_of":"2026-10-22"}]}