48 datasets, 176 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.
https://api.tigzig.com/downloads (JSON).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.6M rows3x daily | parquet~179 MB | csv.gz~232 MBcsv.zip~252 MB | MethodologyValidation | ||
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 | MethodologyValidation | 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 | MethodologyValidation | ||
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 | 571 rows4x daily | csv~170 KB | MethodologyValidation | JSONjson~230 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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidation | ||
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 | 132 rowstwice daily | parquet~10 KB | csv~50 KB | MethodologyValidation | ||
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 | MethodologyValidation | ||
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 | 132 rows3x daily | parquet~50 KB | csv~470 KB | MethodologyValidation | ||
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 | 32 rows3x daily | parquet~1 KB | csv~10 KB | MethodologyValidation | ||
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 | Methodology | ||
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 | Methodology | ||
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 | Methodology | ||||
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.7K rowsmonthly | csv~190 KB | MethodologyValidationSector guideColumn guide | |||
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 reporting date, long format. API docs · Methodology · Validation · Open in the tool
| ||||||
| US insurance company investments (Fed Z.1) | ~10K rowsquarterly | csv~830 KB | MethodologyValidationSeries listColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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 | MethodologyValidationColumn guide | |||
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~720 KB | csv.gz~650 KBcsv.zip~650 KB | MethodologyValidation | ||
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 | MethodologyValidation | ||
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 | MethodologyValidation | ||
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~860 KBcsv.zip~860 KB | MethodologyValidation | ||
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 | MethodologyValidation | ||
Encumbrance events (SAST Reg 31/32) Promoter share pledge creation, release and invocation events. | ||||||
| Surveillance flags | 592 rows4x daily | parquet~10 KB | csv.gz~1 KBcsv.zip~1 KB | MethodologyValidation | ||
Surveillance flags Stocks currently under exchange surveillance measures. | ||||||
| Related-party transactions | ~372K rowsweekly | parquet~10 MB | csv.gz~9 MBcsv.zip~9 MB | MethodologyValidation | ||
Related-party transactions Related-party transactions disclosed by listed companies. | ||||||
| All VIGIL tables in one SQLite file | ~446K rows4x daily | MethodologyValidation | ||||
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 | 736 rowswhen the source publishes | csv~320 KB | MethodologyValidationColumn guide | |||
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 | 817 rowswhen the source publishes | csv~200 KB | MethodologyValidationColumn guide | |||
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~140 KB | MethodologyValidationColumn guide | |||
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. 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~57 MBcsv.zip~57 MB | MethodologyValidation | ||
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.gz~580 KBcsv.zip~580 KB | MethodologyValidation | ||
Matches One row per match across every format: teams, venue, date, toss and result. | ||||||
| Match players | ~296K rowstwice daily | parquet~1 MB | csv.gz~2 MBcsv.zip~2 MB | MethodologyValidation | ||
Match players Who played in each match, one row per player per match. | ||||||
| Player register | ~19K rowstwice daily | parquet~520 KB | csv.gz~470 KBcsv.zip~470 KB | MethodologyValidation | ||
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 | MethodologyValidation | ||||
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~18 MBcsv.zip~18 MB | MethodologyValidation | ||
Deliveries: Test, men A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: ODI, men | ~1.4M rowstwice daily | parquet~4 MB | csv.gz~16 MBcsv.zip~16 MB | MethodologyValidation | ||
Deliveries: ODI, men A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: T20 internationals, men | ~816K rowstwice daily | parquet~3 MB | csv.gz~10 MBcsv.zip~10 MB | MethodologyValidation | ||
Deliveries: T20 internationals, men A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: Test, women | ~47K rowstwice daily | parquet~100 KB | csv.gz~500 KBcsv.zip~500 KB | MethodologyValidation | ||
Deliveries: Test, women A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: ODI, women | ~323K rowstwice daily | parquet~900 KB | csv.gz~4 MBcsv.zip~4 MB | MethodologyValidation | ||
Deliveries: ODI, women A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: T20 internationals, women | ~497K rowstwice daily | parquet~2 MB | csv.gz~6 MBcsv.zip~6 MB | MethodologyValidation | ||
Deliveries: T20 internationals, women A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
| Deliveries: IPL | ~296K rowstwice daily | parquet~920 KB | csv.gz~3 MBcsv.zip~3 MB | MethodologyValidation | ||
Deliveries: IPL A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both. | ||||||
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.