Built and run by one person.

How do I download the entire India mutual fund NAV database in one file?

Two no-code ways on the MFPRO Data & API screen. Pick a basket of up to 20 schemes and any period and pull their full NAV history as CSV, or take the entire database - every AMFI scheme since April 2006, 37M+ rows - in one click. The full-database download comes in Parquet (~170 MB), CSV, TSV (~235 MB each) and SQLite (~1.3 GB), gzip or zip, rebuilt three times a day from AMFI.

If you only want the current NAV of every fund, you do not need any of that. A whole-universe snapshot returns one row per scheme - 38,000+ rows, 22 columns, about 9.7 MB of plain CSV, in roughly a second: https://api.tigzig.com/mf/v1/download?format=latest. It carries the scheme master, the latest NAV and each scheme's average AUM together, as raw CSV, so it opens in a browser or Excel and works with pd.read_csv straight off the URL with no unzipping. Two caveats worth knowing: it is each scheme's most recent NAV, so wound-up schemes carry their final NAV from whenever they closed (filter is_active for the roughly 8,600 still publishing); and one scheme code is a single plan-and-option variant rather than a whole fund, so to size a fund you sum its family.

Everything on that screen is also a plain HTTP API endpoint if you prefer code. No key, no sign-up.

If you are a heavy user, run it as your own service instead of calling the API. The Parquet copy is about 169 MB and carries every scheme and every NAV date back to April 2006. On a Python backend that needs one package, duckdb, which queries the Parquet file where it sits - no database server to install - and Polars reads the same file just as happily. Querying a file on the same container or the same network is fast, and there is no rate limit to work around because there is no API call. To stay current, point a scheduled job at the manifest, which lists every download with its size, its row count and the time it was built: if the build time has moved since your last run, pull the file again.

Download screen: mfpro.tigzig.com -> Data & API. API reference: https://www.tigzig.com/apis/mf-nav. Analytics hub: https://www.tigzig.com/mutual-funds. Live uptime: status.tigzig.com.

Building something like this? How I work covers the rates, the availability and what I take on.

← All Agents FAQ