48 datasets, 179 files from Indian mutual funds, global macro and markets, NSE corporate red flags and cricket. Free, no sign-up. Click a file to download it, or to copy its link. shows more file types, and opens what a dataset holds.
- AI agents: the full list of datasets, with a direct link to every file, is
https://api.tigzig.com/downloads(JSON). - Refreshed on a schedule. Most datasets here refresh automatically. 32 of the 48 refresh two to four times a day. 9 refresh weekly, monthly or quarterly, in step with their sources. 7 update when their sources publish. Each dataset below shows how often it updates and the date of its latest data.
- Every link is the file itself, so it works in a script exactly as shown.
MF NAV (mutual funds)5 datasetsOpen the appAPI docsFiles index (JSON) | ||||||
|---|---|---|---|---|---|---|
| NAV history, every scheme, every day | ~37.7M rows3x daily | parquet~179 MB | csv.gz~233 MBcsv.zip~252 MB | |||
NAV history, every scheme, every day 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. | ||||||
| Scheme universe with latest NAV | ~38K rows3x daily | parquet~2 MB | csv~10 MBcsv.gz~1 MB | CSVcsv.zip~1 MB |
||
Scheme universe with latest NAV 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. | ||||||
| Scheme details: fund size, scheme document, expense ratio | ~11K rows4x daily | parquet~1 MB | csv.gz~3 MB | |||
Scheme details: fund size, scheme document, expense ratio 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. | ||||||
| Scheme details: rows that could not be matched cleanly | 550 rows4x daily | csv~160 KB | JSONjson~220 KB |
|||
Scheme details: rows that could not be matched cleanly The rows where AMFI's daily feed and the scheme documents could not be matched cleanly, with the reason for each. | ||||||
| Mutual fund portfolio holdings / composition (selected equity funds) | ~22K rowsmonthly | csv~5 MB | ||||
Mutual fund portfolio holdings / composition (selected equity funds) 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. API docs · Methodology · Validation · Open in the tool
| ||||||
SIF (Specialized Investment Funds)5 datasetsOpen the appFiles index (JSON) | ||||||
| SIF NAV history, every scheme, every day | ~17K rowstwice daily | parquet~100 KB | csv~2 MB | |||
SIF NAV history, every scheme, every day One row per SIF scheme per date, every NAV AMFI has published since the category began in October 2025. | ||||||
| SIF scheme master | 135 rowstwice daily | parquet~10 KB | csv~50 KB | |||
SIF scheme master One row per SIF scheme: codes, ISINs, fund house, SEBI strategy, plan and option, first and latest NAV, and the latest quarterly average AUM. | ||||||
| SIF average AUM by quarter | 295 rowsweekly | parquet~10 KB | csv~40 KB | |||
SIF average AUM by quarter One row per SIF scheme per quarter: AMFI's quarterly average AUM, in Rs lakhs as filed and in Rs crore. | ||||||
| SIF scheme details: scheme document, expense ratio, fund size | 135 rows3x daily | parquet~50 KB | csv~470 KB | |||
SIF scheme details: scheme document, expense ratio, fund size One row per SIF scheme, latest values only: what the fund's scheme summary document at AMFI says (managers, launch date, benchmark, risk band, exit load, terms), the latest TER and base expense ratio, and the latest quarterly average AUM with its quarter. Same first 60 columns as the MF scheme details file. | ||||||
| SIF scheme details: open data issues | 35 rows3x daily | parquet~1 KB | csv~10 KB | |||
SIF scheme details: open data issues The open issues behind blanks or as-filed values in the SIF scheme details file: funds with no scheme document at AMFI, TER filings that stopped, manager entries not split. A row disappears once the issue clears. | ||||||
TREMOR (macro and markets)15 datasetsOpen the appAPI docsFiles index (JSON) | ||||||
| Macro indicators, all series | ~288K rows3x daily | parquet~2 MB | csv.gz~2 MBcsv.zip~2 MB | |||
Macro indicators, all series Long format: one row per indicator per date, across the publicly visible macro, credit, valuation, India, global and FX series. Join to indicator_config for each series' name, units and notes. API docs · Methodology · Open in the tool
| ||||||
| Market prices, daily OHLCV | ~136K rows3x daily | parquet~5 MB | csv.gz~3 MBcsv.zip~3 MB | |||
Market prices, daily OHLCV Daily open, high, low, close and volume for the market symbols TREMOR tracks: major equity indices, the US 10Y yield, the dollar index, gold, copper and crude oil.
| ||||||
| Indicator dictionary | 369 rows3x daily | parquet~30 KB | csv.gz~20 KBcsv.zip~20 KB | |||
Indicator dictionary One row per macro series: display name, category, units, and notes on methodology and known quirks. The data dictionary for macro_indicators. API docs · Methodology · Open in the tool
| ||||||
| All TREMOR tables in one database file | ~424K rows3x daily | |||||
All TREMOR tables in one database file Every table above in a single file. Open it locally and every table is already loaded. API docs · Methodology · Open in the tool
| ||||||
| India bank credit by sector (RBI) | ~3.9K rowsmonthly | csv~250 KB | ||||
India bank credit by sector (RBI) Outstanding bank credit by economic sector in India, monthly, from the RBI sectoral deployment of bank credit releases, in crore rupees. One row per sector per month, long format, with the RBI date that stands for the month. Each month carries the latest figure RBI has published for it; totals from April 2019 to March 2021 are on the all-bank basis RBI used from April 2021 (see the methodology page). API docs · Methodology · Validation · Open in the tool
| ||||||
| US insurance company investments (Fed Z.1) | ~10K rowsquarterly | csv~830 KB | ||||
US insurance company investments (Fed Z.1) Financial assets of US life and property-casualty insurers by asset class, quarterly, in millions of US dollars. One row per series per quarter, long format, with the tree position of each series. API docs · Methodology · Validation · Open in the tool
| ||||||
| US bank lending to non-bank financial firms (NDFI), bank by bank | ~4.3K rowsquarterly | csv~880 KB | ||||
US bank lending to non-bank financial firms (NDFI), bank by bank Every US bank's loans to non-depository financial institutions (mortgage lenders, business lenders, private equity and private credit funds, consumer lenders and others), unused commitments, credit quality and capital, one row per bank per quarter since the line was added to the Call Report in Q4 2024. API docs · Methodology · Validation · Open in the tool
| ||||||
| US banks: loans, delinquency and charge-offs (FDIC) | 102 rowsquarterly | csv~60 KB | ||||
US banks: loans, delinquency and charge-offs (FDIC) All FDIC-insured banks added together, quarterly since 2001: loan balances by type, 30-89 and 90+ days past due, nonaccrual, noncurrent and net charge-offs. One row per quarter, one column per measure; units are in the column dictionary. API docs · Methodology · Validation · Open in the tool
| ||||||
| US credit unions: loans, delinquency and charge-offs (NCUA) | 88 rowsquarterly | csv~60 KB | ||||
US credit unions: loans, delinquency and charge-offs (NCUA) All federally insured credit unions added together, quarterly since 2002: loan balances by type, delinquency and net charge-offs, as filed with NCUA. One row per quarter, one column per measure; units are in the column dictionary. API docs · Methodology · Validation · Open in the tool
| ||||||
| US household debt and delinquency (NY Fed) | 110 rowsquarterly | csv~50 KB | ||||
US household debt and delinquency (NY Fed) US household debt from consumer credit files, quarterly since 1999 (most series from 2003): balances by product, 90+ days past due, flow into delinquency, originations, credit limits, foreclosures and bankruptcies. One row per quarter, one column per measure; units are in the column dictionary. API docs · Methodology · Validation · Open in the tool
| ||||||
| Trump 2025 annual disclosure: business entities (OGE 278e, Part 2 Schedule 1) | 501 rowswhen the source publishes | csv~100 KB | ||||
Trump 2025 annual disclosure: business entities (OGE 278e, Part 2 Schedule 1) Operating companies, golf and resort properties, licensing and crypto entities in the 2025 annual disclosure, one row per entity, with value and income as filed. Many incomes are exact dollar amounts. API docs · Methodology · Validation · Open in the tool
| ||||||
| Trump 2025 annual disclosure: holdings (OGE 278e, Part 6) | ~6.2K rowswhen the source publishes | csv~890 KB | ||||
Trump 2025 annual disclosure: holdings (OGE 278e, Part 6) Securities, funds, bonds and cash held across Donald Trump's accounts and trusts in the 2025 annual disclosure, one row per holding, with value and income ranges as filed. API docs · Methodology · Validation · Open in the tool
| ||||||
| Trump 2025 annual disclosure: positions, agreements, spouse, liabilities, gifts (OGE 278e) | 40 rowswhen the source publishes | csv~10 KB | ||||
Trump 2025 annual disclosure: positions, agreements, spouse, liabilities, gifts (OGE 278e) The five small parts of the 2025 annual disclosure in one table, with a part column: positions held (Part 1), agreements (Part 3), spouse assets and income (Part 5), liabilities (Part 8), and gifts and travel (Part 9). Text is as extracted from the filing. API docs · Methodology · Validation · Open in the tool
| ||||||
| Trump 2025 annual disclosure: transactions (OGE 278e, Part 7) | ~21K rowswhen the source publishes | csv~2 MB | ||||
Trump 2025 annual disclosure: transactions (OGE 278e, Part 7) Every 2025 trade in Donald Trump's annual financial disclosure that was not already reported on a 278-T, one row per trade, with the value range as filed. The 278-T trades are a separate dataset (tremor.trump_trades). API docs · Methodology · Validation · Open in the tool
| ||||||
| Trump stock and bond trades (OGE 278-T filings) | ~8.4K rowswhen the source publishes | csv~2 MB | ||||
Trump stock and bond trades (OGE 278-T filings) Every transaction in Donald Trump's periodic transaction reports (OGE Form 278-T) since January 2026, one row per trade. Values are ranges as filed. Rows were read from the scanned PDFs by three independent methods with a 2-of-3 vote. API docs · Methodology · Validation · Open in the tool
| ||||||
VIGIL (India red flags)11 datasetsOpen the appAPI docsFiles index (JSON) | ||||||
| Credit ratings | ~14K rows4x daily | parquet~730 KB | csv.gz~650 KBcsv.zip~650 KB | |||
Credit ratings Instrument-level credit rating actions on NSE-listed companies from every rating agency, with the earlier rating alongside. | ||||||
| Insider trading disclosures | ~41K rows4x daily | parquet~3 MB | csv.gz~2 MBcsv.zip~2 MB | |||
Insider trading disclosures Promoter, director and key managerial personnel buy, sell and pledge transactions filed under the insider trading regulations. | ||||||
| Promoter pledges, latest quarter | ~1.6K rows4x daily | parquet~180 KB | csv.gz~130 KBcsv.zip~130 KB | |||
Promoter pledges, latest quarter Current promoter pledge and encumbrance levels per listed company. A snapshot of the latest quarter, not a history. | ||||||
| Substantial acquisitions (SAST Reg 29) | ~14K rows4x daily | parquet~1 MB | csv.gz~870 KBcsv.zip~870 KB | |||
Substantial acquisitions (SAST Reg 29) Disclosures of substantial acquisition or sale of shares under the takeover code. | ||||||
| Encumbrance events (SAST Reg 31/32) | ~2.1K rows4x daily | parquet~190 KB | csv.gz~130 KBcsv.zip~130 KB | |||
Encumbrance events (SAST Reg 31/32) Promoter share pledge creation, release and invocation events. | ||||||
| Surveillance flags | 578 rows4x daily | parquet~10 KB | csv.gz~1 KBcsv.zip~1 KB | |||
Surveillance flags Stocks currently under exchange surveillance measures. | ||||||
| Related-party transactions | ~419K rowsweekly | parquet~12 MB | csv.gz~11 MBcsv.zip~11 MB | |||
Related-party transactions Related-party transactions disclosed by listed companies. | ||||||
| All VIGIL tables in one SQLite file | ~493K rows4x daily | |||||
All VIGIL tables in one SQLite file Every table above in a single file. Open it locally and every table is already loaded. API docs · Methodology · Validation · Open in the tool
| ||||||
| BRSR ESG data, one row per company | 792 rowswhen the source publishes | csv~350 KB | ||||
BRSR ESG data, one row per company One row per listed company from its latest Business Responsibility and Sustainability Report (BRSR): revenue, workforce by gender and type, wages and pay gaps, board and KMP, turnover, geography, parental leave and complaints, with prior-year complaint figures where the filing has them. Same columns as the BRSR Aggregate Data download in VIGIL. Values are as filed, with known unit errors corrected in the adjusted revenue column. API docs · Methodology · Validation · Open in the tool
| ||||||
| BRSR data quality flags | 910 rowswhen the source publishes | csv~220 KB | ||||
BRSR data quality flags One row per BRSR value that VIGIL has flagged, corrected or excluded, for each company's current filing year: values filed in the wrong unit, consolidated figures, placeholder values and internal mismatches, with the action taken and the evidence. API docs · Methodology · Validation · Open in the tool
| ||||||
| Corporate signals per company (VIGIL Signals table) | ~2.5K rows4x daily | csv~230 KB | ||||
Corporate signals per company (VIGIL Signals table) One row per listed company VIGIL tracks, with the count of credit rating actions, rating red flags, insider trading disclosures, takeover filings, encumbrance events and related party transactions, the promoter pledge share and the surveillance status, plus the 13 VIGIL Flags: for each event flag the date it last fired, and yes or no for the four that describe the current position. The VIGIL Signals table at All time, unfiltered. API docs · Methodology · Validation · Open in the tool
| ||||||
Cricket (ball by ball)12 datasetsOpen the appAPI docsFiles index (JSON) | ||||||
| Every delivery, all formats | ~5.1M rowstwice daily | parquet~14 MB | csv.gz~58 MBcsv.zip~58 MB | |||
Every delivery, all formats One row per ball across Test, ODI and T20 internationals, men's and women's, plus the IPL. Filter on the gender and team_type columns. | ||||||
| Matches | ~11K rowstwice daily | parquet~360 KB | csv~3 MBcsv.gz~580 KB | CSVcsv.zip~590 KB |
||
Matches One row per match across every format: teams, venue, date, toss and result. | ||||||
| Match players | ~298K rowstwice daily | parquet~1 MB | csv~13 MBcsv.gz~2 MB | CSVcsv.zip~2 MB |
||
Match players Who played in each match, one row per player per match. | ||||||
| Player register | ~19K rowstwice daily | parquet~520 KB | csv~1 MBcsv.gz~470 KB | CSVcsv.zip~470 KB |
||
Player register One row per person, with the identifiers used across the other tables. | ||||||
| All cricket tables in one database file | ~5.4M rowstwice daily | |||||
All cricket tables in one database file Every table above in a single file. Open it locally and every table is already loaded. API docs · Methodology · Validation · Open in the tool
| ||||||
| Deliveries: Test, men | ~1.7M rowstwice daily | parquet~3 MB | csv.gz~19 MBcsv.zip~19 MB | |||
Deliveries: Test, men A slice of ball_by_ball: Test, men only. | ||||||
| Deliveries: ODI, men | ~1.4M rowstwice daily | parquet~4 MB | csv.gz~16 MBcsv.zip~16 MB | |||
Deliveries: ODI, men A slice of ball_by_ball: ODI, men only. | ||||||
| Deliveries: T20 internationals, men | ~820K rowstwice daily | parquet~3 MB | csv.gz~10 MBcsv.zip~10 MB | |||
Deliveries: T20 internationals, men A slice of ball_by_ball: T20 internationals, men only. | ||||||
| Deliveries: Test, women | ~47K rowstwice daily | parquet~100 KB | csv.gz~500 KBcsv.zip~500 KB | |||
Deliveries: Test, women A slice of ball_by_ball: Test, women only. | ||||||
| Deliveries: ODI, women | ~324K rowstwice daily | parquet~900 KB | csv.gz~4 MBcsv.zip~4 MB | |||
Deliveries: ODI, women A slice of ball_by_ball: ODI, women only. | ||||||
| Deliveries: T20 internationals, women | ~500K rowstwice daily | parquet~2 MB | csv.gz~6 MBcsv.zip~6 MB | |||
Deliveries: T20 internationals, women A slice of ball_by_ball: T20 internationals, women only. | ||||||
| Deliveries: IPL | ~296K rowstwice daily | parquet~920 KB | csv.gz~3 MBcsv.zip~3 MB | |||
Deliveries: IPL A slice of ball_by_ball: IPL only. | ||||||
No dataset matches. Try a shorter word, or pick All.
▶HTTP range requests supported: query a parquet file in place
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.
SELECT count(*) FROM read_parquet('https://api.tigzig.com/mf/v1/download/amfi_nav_master.parquet');In JavaScript, lakeql is a lightweight SQL engine for parquet files that runs in a browser or a Worker, with no server in between. How to use it.
Licence
Cricket (ball by ball): ODC-BY-1.0 (licence text). Cricsheet (cricsheet.org). The tables here are built from the Cricsheet data and refreshed twice daily. TigZig is not affiliated with or endorsed by Cricsheet. Cricsheet is credited as the source of the underlying match data under the terms of the ODC-BY 1.0 licence.