# MFPro NAV Master: Data Dictionary

Every field, what it means, what it covers, and where it is imperfect.

Source data: AMFI official NAV files - 37 million and growing daily, 38,000+ (about 8,600 active, the rest matured or merged), 2006-04-01 to present. Last updated: 2026-08-01. Interactive tool: https://mfpro.tigzig.com

## What this dataset is

Daily NAVs for every Indian mutual fund scheme in AMFI's public records: all scheme types (open-ended, closed-ended, interval), April 2006 onward, including matured schemes. Source: AMFI official files (daily NAVAll.txt plus the historical NAV archives). Updated 3x daily.

## Coverage

| Item | Value |
| --- | --- |
| **NAV rows** | 37 million and growing daily |
| **Schemes** | 38,000+ (about 8,600 active, the rest matured or merged) |
| **Date span** | 2006-04-01 to present |
| **Scheme types** | Open Ended, Close Ended, Interval |
| **AMCs** | 71, including defunct houses (ABN AMRO, Fortis, Standard Chartered, Benchmark) |
| **Update cadence** | 3x daily from AMFI, with a 7-day self-healing lookback across all scheme types |

## Table: nav_master

NAV history (one row per scheme per day)

**Grain:** One row per (scheme_code, date). Unique index enforced.

| Field | Type | Description |
| --- | --- | --- |
| `scheme_code` | INTEGER | AMFI's numeric scheme identifier (4-7 digits). Stable for the life of a scheme plan+option. Join key to scheme_meta. |
| `date` | DATE | NAV declaration date (YYYY-MM-DD). |
| `nav` | DECIMAL(18,4) | Net Asset Value per unit in rupees, as published by AMFI. |
| `scheme_name` | VARCHAR | Scheme name as it appeared in AMFI's file on that date. Names can change over a scheme's life; use the scheme master's scheme_name for the current canonical name. |
| `isin` | VARCHAR | ISIN (Div Payout / Growth variant) as published on that date. Can be blank for older rows. For lookups use the scheme master's isin; the NAV API resolves any of a scheme's ISINs, including the reinvestment ISIN and prior ISINs. |

## Table: scheme_master

Table: scheme_master

**Grain:** One row per scheme. The scheme-level master: identifiers, names, categories, plan and option, dates, flags, TXIC, plus each scheme's latest quarterly AAUM and latest NAV. Downloadable as a single small file from the Data & API tab (Download Scheme Master) or GET /mf/v1/download?format=latest. Naming note: the download file is amfi_nav_master_latest.csv / .parquet, and the underlying table appears as scheme_meta in the API's schema; all of these are one and the same dataset.

| Field | Type | Description |
| --- | --- | --- |
| `scheme_code` | INTEGER | AMFI scheme code. Primary key. |
| `scheme_name` | VARCHAR | Current scheme name, following the latest AMFI filing. Fund houses are renaming schemes to match the SEBI Feb-2026 true-to-label rule, and this field updates with each filing; nav_master.scheme_name keeps the name as it appeared on each date. |
| `amc` | VARCHAR | Asset Management Company name, as listed by AMFI. 70+ AMCs including defunct houses. |
| `scheme_type` | VARCHAR | One of exactly three values: 'Open Ended Schemes', 'Close Ended Schemes', 'Interval Fund Schemes'. From the AMFI header prefix. |
| `category` | VARCHAR | Full raw category text from the AMFI header (audit field). Modern: 'Equity Scheme - Large Cap Fund'. Old-style: single words like 'Income'. Prefer the clean fields below. |
| `category_group` | VARCHAR | Raw group text before mapping (audit field). 20+ distinct values and growing: AMFI is re-filing schemes under new group headers through the SEBI Feb-2026 recategorization, so old and new group names coexist. For analysis use category_group_clean. |
| `category_sub` | VARCHAR | SEBI sub-category (e.g. 'Large Cap Fund', 'Liquid Fund'). 50+ distinct values: old 2017 names and new SEBI Feb-2026 names (e.g. 'Short Duration Fund' and 'Short Term Fund') coexist while fund houses re-file, stored as-filed. BLANK for ambiguous old-style schemes by design; those rows will not appear in sub-category filters. |
| `category_group_clean` | VARCHAR | RECOMMENDED category field. Exactly 4 values: Equity Scheme, Debt Scheme, Hybrid Scheme, Other Scheme. Every raw group name, old or new, maps in deterministically (Income -> Debt, Growth -> Equity, Balanced -> Hybrid, the new Income/Debt Oriented Schemes -> Debt, etc.). Solution Oriented (discontinued by SEBI in Feb 2026) and Fund of Funds sit under Other Scheme; their schemes stay fully findable via category_group and category_sub. |
| `isin` | VARCHAR | ISIN of the Div Payout / Growth variant. 1:1 with scheme_code where present; can be blank for old matured schemes. All of a scheme's ISINs resolve on the NAV API: this one, the reinvestment ISIN (isin2), and prior ISINs of schemes whose ISIN changed - each returns the same full NAV series. |
| `isin2` | VARCHAR | Div Reinvestment ISIN, present only where the IDCW plan has a distinct reinvestment unit class (about 6,400 schemes). AMFI files it as a second ISIN column and writes '-' when absent. Same scheme_code and same NAV series as isin - payout and reinvestment are sub-options of the same IDCW plan, not a different fund. Blank for most schemes. |
| `first_date` | DATE | First NAV date on record for this scheme. |
| `last_date` | DATE | Most recent NAV date on record. For matured schemes this is their final NAV date. |
| `is_tracked` | BOOLEAN | TRUE for the curated set of funds with additional analytics in the MFPro app. App-internal convenience flag; not included in the download file. |
| `is_stale` | BOOLEAN | TRUE only for the ~50 schemes that have just 1-2 NAV rows in all of AMFI's records (data orphans). Everything else is FALSE, including matured schemes with real history. |
| `txic_code` | VARCHAR | TigZig scheme identifier: a short human-readable code (AMC + type + category + keyword + plan + option, e.g. AX.O.MC.D.G displayed with dots). Deterministic and unique. See the TXIC docs section. |
| `scheme_plan` | VARCHAR | 'Direct', 'Regular', or 'Other' (classified from the scheme name; pre-2013 schemes predate the Direct/Regular split and classify as Other). |
| `scheme_option` | VARCHAR | 'Growth', 'IDCW', 'Bonus', or 'Other' (classified from the scheme name). AMFI names carry traps the classifier handles: 'Growth Plan - Bonus Option' is a Bonus option, a Dividend Yield fund's Growth variant is Growth, and 'Unclaimed IDCW Plan - Growth' (an unclaimed-amounts pool) is Growth. A fund can have several active variants at one scheme code each, so one fund may appear as separate Growth, IDCW and Bonus rows; the rarely-held Bonus variants carry near-zero AAUM. Count funds by name, not by code, if you need fund-level counts. |
| `is_active` | BOOLEAN | TRUE if the scheme published a NAV within the last 45 days. Recomputed on every sync. Use this to filter live vs matured/merged schemes. |
| `aaum_cr` | DOUBLE | Latest available quarterly Average AUM in Rupees Crore for this scheme. What AAUM is and is not (the daily-average definition, new-fund understatement, per-variant grain) is explained in full on the How the Data Is Built page, Scheme AUM section. |
| `aaum_quarter` | VARCHAR | The AMFI quarter label the AAUM comes from, as filed, e.g. 'June-2026'. Schemes can sit on different latest quarters while AMFI publishes a new quarter progressively. |
| `aaum_quarter_end` | DATE | The same quarter as an ISO date (June-2026 becomes 2026-06-30). Sort and filter on this and display the label; the label alone sorts alphabetically and puts March after June. |
| `nav_date` | DATE | Date of the scheme's latest NAV. For matured schemes this is their final NAV date. |
| `nav` | DECIMAL(18,4) | The scheme's latest NAV. For matured schemes this is the final NAV, frozen; check nav_date before treating it as current. In the parquet download nav is a DECIMAL type. |

## Caveats and known quirks

The honest edges of this dataset. Read these before you draw conclusions from a gap or an outlier.

- Old-style schemes (pre-SEBI-2018 categories like Income or Growth) have a blank category_sub by design; AMFI never assigned them a modern sub-category. Filter on category_group_clean instead.

- SEBI reissued the entire categorization framework on 26 February 2026 (new category names, a Life Cycle Funds category, Solution Oriented discontinued). Fund houses re-file through late August 2026, so raw category fields show a mix of old and new vocabulary during the transition. Scheme categories and names in scheme_meta follow the latest AMFI filing; every change is recorded in an internal changelog.

- Closed-ended schemes in the early era (roughly pre-2010) often published NAVs weekly, not daily. Gaps of about 7 days in those series reflect the source cadence of that era, not missing data.

- Where AMFI's daily file and its historical archive disagreed on a NAV (9 records out of about 27,900 overlapping), the daily file's value was kept. Two of the nine were maturity-day par resets in the archive feed for dividend-payout FMPs; the daily file carried the real accrued NAV.

- NAV values are stored to 4 decimal places, matching AMFI's published precision.

- A small set of 50 schemes carries only 1-2 NAV rows in AMFI's records (flagged is_stale = true). They are kept for completeness.

## How to access this data

- **API:** https://api.tigzig.com/mf/v1/ (self-describing catalog; single and bulk NAV, search, downloads)

- **API reference:** [https://www.tigzig.com/apis/mf-nav](https://www.tigzig.com/apis/mf-nav)

- **Bulk downloads:** Full NAV dataset in csv.gz, tsv.gz, parquet and sqlite, plus the scheme_master latest snapshot (format=latest, ~1 MB compressed), via the Data & API tab or GET /mf/v1/download

- **For AI agents:** [https://www.tigzig.com/ai/apis/mf-nav.md](https://www.tigzig.com/ai/apis/mf-nav.md)

---
Source: https://www.tigzig.com/mfpro/data-dictionary

---
Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar
Source: https://www.tigzig.com/mfpro/data-dictionary
Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar.
License: https://www.tigzig.com/terms