{"generated_at":"2026-11-18T18:40:26Z","total_rows":37804387,"docs":"https://www.tigzig.com/apis/mf-nav","data_source":"Source: AMFI (Association of Mutual Funds in India).","disclaimer":"Provided as is, with no guarantee of accuracy, completeness or availability and no support commitment.","terms":"https://api.tigzig.com/mf/v1/terms","files":{"amfi_nav_master.csv.gz":{"format":"csv.gz","size_bytes":233271102,"size_human":"222.5 MB","row_count":37804387},"amfi_nav_master.csv.zip":{"format":"csv.zip","size_bytes":252670231,"size_human":"241.0 MB","row_count":37804387},"amfi_nav_master.tsv.gz":{"format":"tsv.gz","size_bytes":232788287,"size_human":"222.0 MB","row_count":37804387},"amfi_nav_master.tsv.zip":{"format":"tsv.zip","size_bytes":252355436,"size_human":"240.7 MB","row_count":37804387},"amfi_nav_master.parquet":{"format":"parquet","size_bytes":179257059,"size_human":"171.0 MB","row_count":37804387},"amfi_nav_master_latest.csv":{"format":"latest.csv","size_bytes":10125074,"size_human":"9.7 MB","row_count":38550},"amfi_nav_master_latest.csv.gz":{"format":"latest.csv.gz","size_bytes":1195586,"size_human":"1.1 MB","row_count":38550},"amfi_nav_master_latest.csv.zip":{"format":"latest.csv.zip","size_bytes":1195718,"size_human":"1.1 MB","row_count":38550},"amfi_nav_master_latest.parquet":{"format":"latest.parquet","size_bytes":1655118,"size_human":"1.6 MB","row_count":38550},"amfi_nav_master.db.gz":{"format":"sqlite.gz","size_bytes":1472442534,"size_human":"1.37 GB","row_count":37804387,"unpacked_bytes":5536972800,"unpacked_human":"5.16 GB","note":"Unpacks to about 5.5 GB (5,536,972,800 bytes); allow about 7 GB of free disk. nav is a binary float (REAL), so round it to 4 decimal places; the parquet file is exact."},"amfi_nav_master.db.zip":{"format":"sqlite.zip","size_bytes":1472442690,"size_human":"1.37 GB","row_count":37804387,"unpacked_bytes":5536972800,"unpacked_human":"5.16 GB","note":"Unpacks to about 5.5 GB (5,536,972,800 bytes); allow about 7 GB of free disk. nav is a binary float (REAL), so round it to 4 decimal places; the parquet file is exact."}},"validation":{"source_rows":37804387,"all_match":true,"latest_snapshot_rows":38550,"latest_snapshot_match":true,"latest_snapshot_source_rows":38550,"nav_distinct_schemes":38530,"latest_snapshot_active_rows":8909,"latest_snapshot_matured_rows":29641,"latest_snapshot_note":"The snapshot includes EVERY scheme: active ones plus matured schemes carrying their final (frozen) NAV - survivorship-bias free by design. Filter on is_active for live schemes only; nav_date shows how fresh each row is. Column semantics (incl. AAUM granularity + quarter taper): see schema.latest_snapshot in GET /mf/v1/."},"sources":{"MF":{"rows":37785601,"included":true},"SIF":{"included":true,"rows":18786,"schemes":145,"max_nav_date":"2026-11-17"},"note":"Specialized Investment Funds (SIF) are included below the mutual funds. Filter on source = 'MF' (or 'SIF') before computing totals across schemes. SIF codes are AMFI's numeric part, e.g. SIF-120 is scheme_code 120."},"generation_time_seconds":1137.9,"schema_version":5,"schema_changed":"2026-10-21","schema_notes":["v5 (2026-10-21): scheme_details_latest (/mf/v1/download/scheme_details_latest) also holds Specialized Investment Funds (SIF), below the mutual funds, and gains ONE column, `source` ('MF' or 'SIF'), added LAST as column 61. No existing column moved, was renamed or changed type. Filter on source = 'MF' before totals across schemes; per-source counts are in the datasets manifest under scheme_details_latest.sources. data_quality is unchanged (MF only).","v4 (2026-10-21): every NAV file (full history and latest snapshot) now also holds Specialized Investment Funds (SIF), below the mutual funds, and gains ONE column, `source` ('MF' or 'SIF'), added LAST. No existing column moved, was renamed or changed type. SIF scheme_code is the numeric part of AMFI's SIF code (SIF-120 is 120; every MF code is 100027 or above). Filter on source = 'MF' before totals across schemes; per-source row counts are under `sources`.","v3 (2026-10-03): full-history files, no column added, removed or renamed. SQLite: `nav` is now REAL. It was stored as text, so max(nav) and nav > 100 compared strings and returned wrong results; a query that compares nav to a quoted string must now compare it to a number. CSV: `scheme_name` is now always quoted. TSV: no quoting at all; every field is written as-is, so a plain split on tab is correct.","v2 (2026-08-12): on the latest-snapshot files ONLY, the column `aaum_cr` is now `aaum_cr_quarterly_avg`. Same values, same units (Crores), same position - the name now says that it is an AVERAGE over a quarter rather than a point-in-time AUM, which is what readers were assuming. `aaum_quarter` and `aaum_quarter_end` are UNCHANGED. If your code does df['aaum_cr'] it will raise KeyError - rename the reference, nothing else changed. Full-history files are unaffected."],"schema":{"full_history_files":{"applies_to":"csv.gz, csv.zip, tsv.gz, tsv.zip, parquet, sqlite.gz, sqlite.zip","columns":["scheme_code","date","nav","scheme_name","isin","source"],"note":"Only these 6 columns. `source` is 'MF' or 'SIF' (Specialized Investment Funds, rows after the mutual funds). `date` is a STRING (YYYY-MM-DD), not a date type - compare it as a string ('date > '2026-01-01'') or CAST(date AS DATE). Category, AMC and AAUM are NOT here; they are on the latest-snapshot files."},"latest_snapshot_files":{"applies_to":"latest, latest.csv.gz, latest.csv.zip, latest.parquet","note":"One row per scheme, ~38K rows, 23 columns (the last is `source`, 'MF' or 'SIF'): the full scheme master (amc, category, category_sub, category_group, scheme_plan, scheme_option, first_date, last_date, is_active, is_stale) plus latest NAV (nav, nav_date) and latest quarterly AAUM (aaum_cr_quarterly_avg, aaum_quarter). Includes matured schemes with their final frozen NAV - filter is_active for live schemes only."},"query_tip":"The parquet is clustered by scheme_code. Filtering on scheme_code reads about 5 byte ranges; filtering on date or scheme_name, or not filtering, reads all 303 row groups (~300 ranges). To find a fund by name, search the small latest.parquet first, then join to the full file by scheme_code.","see_also":"https://api.tigzig.com/mf/v1/ (full field semantics and the data dictionary)","other_datasets":"scheme_details_latest (60 fields per scheme) and data_quality are listed under the top-level `datasets` key, not under `files`, which holds the NAV files only."},"datasets":{"scheme_details_latest":{"generated_at":"2026-11-18T23:45:16Z","schema_version":1,"row_count":11462,"columns":61,"sources":{"MF":{"row_count":11317},"SIF":{"row_count":145,"included":true}},"url":"https://api.tigzig.com/mf/v1/download/scheme_details_latest?format=parquet","formats":{"parquet":1301804,"csv.gz":2889590},"rows_with":{"amfi_daily":8629,"ssd":11271,"ter":8513},"rows_with_meaning":{"amfi_daily":"rows with an AMFI daily fund AUM figure","ssd":"rows linked to a Scheme Summary Document; a few linked rows have no document date","ter":"rows with a TER filing (ter_date present)"},"source_dates":{"amfi_daily_aum_date":"2026-11-17","ter_date":"2026-11-18","scheme_document_run":"2026-11-18"}},"data_quality":{"generated_at":"2026-11-18T23:45:16Z","schema_version":1,"row_count":563,"url":"https://api.tigzig.com/mf/v1/download/data_quality?format=csv","formats":{"csv":163795,"json":226040}}}}