{"catalog_version":1,"view":"app_detail","app":"sif","app_title":"SIF (Specialized Investment Funds)","status":"ok","generated_at":"2026-10-25T02:27:05Z","summary_url":"https://api.tigzig.com/downloads","source_index_url":"https://sif.tigzig.com/data-catalog.json","query_in_place":{"http_range_requests":true,"formats":["parquet"],"how":"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.","example_sql":"SELECT count(*) FROM read_parquet('https://api.tigzig.com/downloads/sif_nav.parquet');","example_curl":"curl -H \"Range: bytes=-8\" https://api.tigzig.com/downloads/sif_nav.parquet","limits":"Range reads have their own per-IP budget, separate from whole-file downloads. Every response carries X-RateLimit headers."},"datasets":[{"id":"sif.aum_quarterly","title":"SIF average AUM by quarter","description":"One row per SIF scheme per quarter: AMFI's quarterly average AUM, in Rs lakhs as filed and in Rs crore.","category":"funds","kind":"tool_export","publisher":"AMFI (Association of Mutual Funds in India)","coverage":"Oct-Dec 2025 to Jul-Sep 2026","data_as_of":"2026-09-30","update_cadence":"weekly","row_count":295,"tool_url":"https://sif.tigzig.com/","docs_url":"https://sif.tigzig.com/README.txt","methodology_url":"https://sif.tigzig.com/#methodology","validation_url":"https://sif.tigzig.com/#validation","columns":[{"name":"scheme_code","type":"INTEGER","description":"Numeric part of the SIF code (SIF-120 is 120). Integer, never collides with MF codes."},{"name":"aaum_quarter","type":"VARCHAR","description":"The quarter of the AUM figure, named by its end month, e.g. 'June-2026'."},{"name":"aaum_quarter_end","type":"DATE","description":"That quarter's end date."},{"name":"aaum_cr_quarterly_avg","type":"DOUBLE","description":"Quarterly AVERAGE AUM, in Rs crore (aaum_lakhs / 100). Same name as the MF scheme master."},{"name":"aaum_lakhs","type":"DOUBLE","description":"Quarterly average AUM exactly as AMFI publishes it, in Rs lakhs."},{"name":"scheme_name","type":"VARCHAR","description":"Full scheme name as AMFI publishes it."},{"name":"amc","type":"VARCHAR","description":"Fund house as AMFI writes it, e.g. 'qsif SIF'."},{"name":"quarter_start","type":"DATE","description":"The quarter's start date."},{"name":"temp_sif_code","type":"VARCHAR","description":"Display form 'SIF-120'. TEMPORARY: goes away when SIF merges into the MF data."}],"files":[{"format":"csv","role":"data","url":"https://api.tigzig.com/downloads/sif_aaum.csv","size_bytes":38505,"sha256":"7fa6e4f203b9039bfb14e6256ce2ebf214bd2870c56fcd15bb4ea1fca527e1f6","row_count":295,"generated_at":"2026-10-24T23:40:19+00:00"},{"format":"parquet","role":"data","url":"https://api.tigzig.com/downloads/sif_aaum.parquet","size_bytes":8943,"sha256":"894ffdde1a040af7f74a8537fa9d2a30ebea3129231e0fc7b8b282e375d69449","row_count":295,"generated_at":"2026-10-24T23:40:19+00:00","http_range_requests":true}],"app":"sif","parity":{"status":"ok","checked_at":"2026-10-15T06:59:30Z","detail":"sif_aaum: csv = parquet, 295 rows"}},{"id":"sif.data_quality","title":"SIF scheme details: open data issues","description":"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.","category":"funds","kind":"tool_export","publisher":"AMFI (Association of Mutual Funds in India)","coverage":"latest values only","data_as_of":"2026-10-24","update_cadence":"3x daily","row_count":32,"tool_url":"https://sif.tigzig.com/","docs_url":"https://sif.tigzig.com/README.txt","methodology_url":"https://sif.tigzig.com/#scheme-details","validation_url":"https://sif.tigzig.com/#scheme-details-issues","columns":[{"name":"source","type":"VARCHAR","description":"Which link or filing the issue is about: scheme_document_link, scheme_document or ter_filing."},{"name":"as_of","type":"VARCHAR","description":"Date of the filing or the scheme-document check the issue was found in."},{"name":"scheme_code","type":"INTEGER","description":"The SIF scheme the issue affects (numeric part of the SIF code)."},{"name":"name","type":"VARCHAR","description":"Scheme name."},{"name":"category","type":"VARCHAR","description":"SEBI investment strategy of the scheme."},{"name":"issue_code","type":"VARCHAR","description":"Short code for the issue, e.g. no_ssd_filed, ter_behind, managers_not_split."},{"name":"issue","type":"VARCHAR","description":"The issue in plain words, and what it means for the scheme details file."},{"name":"status","type":"VARCHAR","description":"Always 'open'. This is a log of OPEN issues: a row disappears once the issue clears."},{"name":"detail","type":"VARCHAR","description":"Supporting detail: fund id, SEBI code, the filed values."}],"files":[{"format":"csv","role":"data","url":"https://api.tigzig.com/downloads/sif_data_quality.csv","size_bytes":12598,"sha256":"2ab070cc170470e66852b339f96ccbfd872686eaf68fcc58d7acef9be673f765","row_count":32,"generated_at":"2026-10-24T23:40:19+00:00"},{"format":"parquet","role":"data","url":"https://api.tigzig.com/downloads/sif_data_quality.parquet","size_bytes":4523,"sha256":"7938de07eb1559b87bef2293939445a5e71d3ccfdb081bb98c9853b01e45457e","row_count":32,"generated_at":"2026-10-24T23:40:19+00:00","http_range_requests":true}],"app":"sif","parity":{"status":"ok","checked_at":"2026-10-24T10:57:11Z","detail":"sif_data_quality: csv = parquet, 32 rows"}},{"id":"sif.nav_history","title":"SIF NAV history, every scheme, every day","description":"One row per SIF scheme per date, every NAV AMFI has published since the category began in October 2025.","category":"funds","kind":"tool_export","publisher":"AMFI (Association of Mutual Funds in India)","coverage":"2025-10-08 to 2026-10-23","data_as_of":"2026-10-23","update_cadence":"twice daily","row_count":16539,"tool_url":"https://sif.tigzig.com/","docs_url":"https://sif.tigzig.com/README.txt","methodology_url":"https://sif.tigzig.com/#methodology","validation_url":"https://sif.tigzig.com/#validation","columns":[{"name":"scheme_code","type":"INTEGER","description":"Numeric part of the SIF code (SIF-120 is 120). Integer, never collides with MF codes."},{"name":"date","type":"DATE","description":"NAV date."},{"name":"nav","type":"DOUBLE","description":"The NAV as filed (latest NAV in the scheme master)."},{"name":"scheme_name","type":"VARCHAR","description":"Full scheme name as AMFI publishes it."},{"name":"isin","type":"VARCHAR","description":"The scheme's primary ISIN (the payout ISIN on an IDCW scheme)."},{"name":"isin2","type":"VARCHAR","description":"Reinvestment ISIN of the SAME scheme, where one exists. Two identifiers, one scheme."},{"name":"amc","type":"VARCHAR","description":"Fund house as AMFI writes it, e.g. 'qsif SIF'."},{"name":"upload_ts","type":"TIMESTAMP","description":"AMFI's publication timestamp, stored as filed: it is IST despite the trailing Z."},{"name":"temp_sif_code","type":"VARCHAR","description":"Display form 'SIF-120'. TEMPORARY: goes away when SIF merges into the MF data."}],"files":[{"format":"csv","role":"data","url":"https://api.tigzig.com/downloads/sif_nav.csv","size_bytes":2257142,"sha256":"b00609e66df2ca5a6746761d79fe211d10cceb65a37460f1a672def72d95fb24","row_count":16539,"generated_at":"2026-10-24T23:40:19+00:00"},{"format":"parquet","role":"data","url":"https://api.tigzig.com/downloads/sif_nav.parquet","size_bytes":96294,"sha256":"f97477e4691dff4e1d0265af200ba6fe79b5bb70b39ea6bd3ee33194043d8372","row_count":16539,"generated_at":"2026-10-24T23:40:19+00:00","http_range_requests":true}],"app":"sif","parity":{"status":"ok","checked_at":"2026-10-24T06:27:10Z","detail":"sif_nav: csv = parquet, 16539 rows"}},{"id":"sif.scheme_details_latest","title":"SIF scheme details: scheme document, expense ratio, fund size","description":"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.","category":"funds","kind":"tool_export","publisher":"AMFI (Association of Mutual Funds in India)","coverage":"latest values only","data_as_of":"2026-10-24","update_cadence":"3x daily","row_count":132,"tool_url":"https://sif.tigzig.com/","docs_url":"https://sif.tigzig.com/README.txt","methodology_url":"https://sif.tigzig.com/#scheme-details","validation_url":"https://sif.tigzig.com/#scheme-details-issues","columns":[{"name":"scheme_code","type":"INTEGER","description":"Numeric part of the SIF code (SIF-120 is 120). The primary key, same key as every SIF file."},{"name":"isin","type":"VARCHAR","description":"ISIN for the growth or payout option, as AMFI lists it."},{"name":"isin2","type":"VARCHAR","description":"ISIN for the reinvestment option of the same scheme, where one exists."},{"name":"scheme_name","type":"VARCHAR","description":"Scheme name from AMFI's SIF NAV data, the same as in sif_meta."},{"name":"fund_name_latest","type":"VARCHAR","description":"The fund's current name from AMFI's SIF fund listing. ssd_fund_name is the name as filed in the scheme document."},{"name":"amc","type":"VARCHAR","description":"Fund house (SIF brand) as AMFI writes it, the same as in sif_meta."},{"name":"category_group_clean","type":"VARCHAR","description":"'Equity Scheme' or 'Hybrid Scheme' (MF's words), the same as in sif_meta."},{"name":"category_sub","type":"VARCHAR","description":"The SEBI investment strategy, e.g. 'Equity Long-Short Fund', the same as in sif_meta."},{"name":"scheme_plan","type":"VARCHAR","description":"Direct or Regular, the same as in sif_meta."},{"name":"is_active","type":"BOOLEAN","description":"True if the scheme published a NAV within the last 45 days."},{"name":"amfi_ssd_fund_id","type":"VARCHAR","description":"AMFI's fund id, e.g. 'S-10'. One fund covers all its plans and options, so this groups the rows of one fund."},{"name":"fund_dedup_flag","type":"BOOLEAN","description":"Always blank for SIF. In the MF file it marks one row per fund so the fund's daily AUM is counted once; SIF has no fund-level AUM. Count funds with amfi_ssd_fund_id."},{"name":"amfi_daily_fund_name","type":"VARCHAR","description":"Always blank for SIF: AMFI's daily fund performance data carries no SIF. Kept so the columns match the MF file."},{"name":"amfi_daily_fund_aum_cr_all_plans","type":"DOUBLE","description":"Always blank for SIF (no daily AUM exists). Use aaum_cr_quarterly_avg."},{"name":"amfi_daily_aum_date","type":"DATE","description":"Always blank for SIF. Use aaum_quarter_end."},{"name":"amfi_daily_aum_flag","type":"VARCHAR","description":"Always blank for SIF."},{"name":"amfi_daily_riskometer","type":"VARCHAR","description":"Always blank for SIF. See ssd_riskometer."},{"name":"amfi_daily_riskometer_benchmark","type":"VARCHAR","description":"Always blank for SIF."},{"name":"amfi_daily_benchmark","type":"VARCHAR","description":"Always blank for SIF. See ssd_benchmark_tier1_filed."},{"name":"amfi_daily_benchmark_filed","type":"VARCHAR","description":"Always blank for SIF."},{"name":"ssd_doc_date","type":"TIMESTAMP","description":"Last modified time of the fund's scheme summary document on AMFI's server. Documents are checked daily."},{"name":"ssd_fund_name","type":"VARCHAR","description":"Fund name as filed in the scheme summary document."},{"name":"ssd_fund_type","type":"VARCHAR","description":"Open ended or interval, as filed."},{"name":"ssd_sebi_category","type":"VARCHAR","description":"SEBI category as filed in the document."},{"name":"ssd_option_names","type":"VARCHAR","description":"Plans and options as listed in the document."},{"name":"ssd_fund_managers","type":"VARCHAR","description":"Fund managers as filed, 'Name (since YYYY-MM-DD); ...'. A few documents put several people in one entry; those are shown as filed and listed in sif_data_quality."},{"name":"ssd_allotment_date","type":"DATE","description":"The fund's allotment (launch) date as filed."},{"name":"ssd_nfo_open_date","type":"DATE","description":"New fund offer opening date as filed."},{"name":"ssd_nfo_close_date","type":"DATE","description":"New fund offer closing date as filed."},{"name":"ssd_reopen_date","type":"DATE","description":"Date the fund reopened for continuous sale, as filed."},{"name":"ssd_maturity_date","type":"DATE","description":"Maturity date as filed. No SIF files one today."},{"name":"ssd_benchmark_tier1_filed","type":"VARCHAR","description":"Tier 1 benchmark exactly as filed. The same index is often written several ways; use ssd_benchmark_tier1_std to group."},{"name":"ssd_benchmark_tier1_std","type":"VARCHAR","description":"Tier 1 benchmark in one standard spelling, the same as the MF file uses ('NIFTY 500 Total Return Index (TRI)' and 'Nifty 500 TRI' are both 'Nifty 500 TRI'). Only spelling changes, never the index. A custom composite benchmark is the filed name tidied. Use this one to group or compare funds."},{"name":"ssd_benchmark_tier2_filed","type":"VARCHAR","description":"Tier 2 benchmark exactly as filed (often 'NA')."},{"name":"ssd_benchmark_tier2_std","type":"VARCHAR","description":"Tier 2 benchmark in the same standard spelling. Blank where none is filed or it is filed as not applicable (NA, --)."},{"name":"ssd_riskometer","type":"VARCHAR","description":"Current risk band as filed in the document."},{"name":"ssd_riskometer_level","type":"VARCHAR","description":"The risk band read from ssd_riskometer, e.g. 'Risk Band 3'."},{"name":"ssd_potential_risk_class","type":"VARCHAR","description":"Potential Risk Class, as filed (often 'NA')."},{"name":"ssd_objective","type":"VARCHAR","description":"Investment objective, as filed."},{"name":"ssd_asset_allocation","type":"VARCHAR","description":"Permitted asset allocation, as filed."},{"name":"ssd_exit_load","type":"VARCHAR","description":"Exit load, as filed."},{"name":"ssd_min_application_amount","type":"VARCHAR","description":"Minimum application amount, as filed."},{"name":"ssd_min_additional_amount","type":"VARCHAR","description":"Minimum additional purchase amount, as filed."},{"name":"ssd_terms_sip","type":"VARCHAR","description":"SIP, SWP and STP terms as filed, 'Label: value | Label: value'."},{"name":"ssd_terms_redemption","type":"VARCHAR","description":"Redemption and switch terms as filed, in the same form."},{"name":"ssd_terms_other","type":"VARCHAR","description":"Other filed terms such as swing pricing, in the same form."},{"name":"ssd_face_value","type":"VARCHAR","description":"Face value per unit, as filed."},{"name":"ssd_expense_actual","type":"VARCHAR","description":"Expense ratio text as filed in the document. The current TER is in the ter_ columns."},{"name":"ssd_side_pocketing","type":"VARCHAR","description":"Side pocketing details, as filed."},{"name":"ssd_custodian","type":"VARCHAR","description":"Custodian, as filed."},{"name":"ssd_auditor","type":"VARCHAR","description":"Auditor, as filed."},{"name":"ssd_registrar","type":"VARCHAR","description":"Registrar and transfer agent, as filed."},{"name":"ssd_listing_details","type":"VARCHAR","description":"Stock exchange listing details, as filed."},{"name":"ssd_status","type":"VARCHAR","description":"'filed', or 'not_filed_by_amc' where the fund house has filed no scheme document at AMFI (fields then come from AMFI's fund listing)."},{"name":"ssd_withheld_fields","type":"VARCHAR","description":"Names of ssd_ fields left blank because the filed document places values against the wrong labels."},{"name":"ter_date","type":"DATE","description":"Date of the TER values below: the latest filing on or before today in AMFI's SIF TER data."},{"name":"ter_regular","type":"DOUBLE","description":"Total expense ratio of the Regular plan, percent, found only by the exact SEBI scheme code in the fund's document. Daily SIF TER includes that day's trading costs, so it moves day to day."},{"name":"ter_direct","type":"DOUBLE","description":"Total expense ratio of the Direct plan, percent. Same matching."},{"name":"ter_ber_regular","type":"DOUBLE","description":"Base expense ratio (the fund house's fee) of the Regular plan, percent. Steadier than ter_regular."},{"name":"ter_ber_direct","type":"DOUBLE","description":"Base expense ratio of the Direct plan, percent."},{"name":"source","type":"VARCHAR","description":"Always 'SIF'. Tells the rows apart when stacked with the MF file."},{"name":"temp_sif_code","type":"VARCHAR","description":"Display form 'SIF-120'. TEMPORARY: goes away when SIF merges into the MF data."},{"name":"aaum_cr_quarterly_avg","type":"DOUBLE","description":"AMFI's quarterly AVERAGE AUM for THIS scheme (plan and option), Rs crore. Add a fund's rows for the fund total. Same name as the MF scheme master; not a month-end or daily AUM."},{"name":"aaum_quarter","type":"VARCHAR","description":"The quarter of aaum_cr_quarterly_avg, named by its end month, e.g. 'September-2026'."},{"name":"aaum_quarter_end","type":"DATE","description":"That quarter's end date."}],"files":[{"format":"csv","role":"data","url":"https://api.tigzig.com/downloads/sif_scheme_details_latest.csv","size_bytes":465584,"sha256":"f7ae585314dfdcf3794673a8fa9a5667398d9355fd34d9bec3c91bf69c9f96f3","row_count":132,"generated_at":"2026-10-24T23:40:19+00:00"},{"format":"parquet","role":"data","url":"https://api.tigzig.com/downloads/sif_scheme_details_latest.parquet","size_bytes":48657,"sha256":"bbfaf332dfc320d0a9a2b71c50b14356daa67d3f0dbea4787eb75384672daf5c","row_count":132,"generated_at":"2026-10-24T23:40:19+00:00","http_range_requests":true}],"app":"sif","parity":{"status":"ok","checked_at":"2026-10-24T10:57:11Z","detail":"sif_scheme_details_latest: csv = parquet, 132 rows"}},{"id":"sif.scheme_master","title":"SIF scheme master","description":"One row per SIF scheme: codes, ISINs, fund house, SEBI strategy, plan and option, first and latest NAV, and the latest quarterly average AUM.","category":"funds","kind":"tool_export","publisher":"AMFI (Association of Mutual Funds in India)","coverage":"2025-10-08 to 2026-10-23","data_as_of":"2026-10-23","update_cadence":"twice daily","row_count":132,"tool_url":"https://sif.tigzig.com/","docs_url":"https://sif.tigzig.com/README.txt","methodology_url":"https://sif.tigzig.com/#methodology","validation_url":"https://sif.tigzig.com/#validation","columns":[{"name":"scheme_code","type":"INTEGER","description":"Numeric part of the SIF code (SIF-120 is 120). Integer, never collides with MF codes."},{"name":"isin","type":"VARCHAR","description":"The scheme's primary ISIN (the payout ISIN on an IDCW scheme)."},{"name":"isin2","type":"VARCHAR","description":"Reinvestment ISIN of the SAME scheme, where one exists. Two identifiers, one scheme."},{"name":"scheme_name","type":"VARCHAR","description":"Full scheme name as AMFI publishes it."},{"name":"amc","type":"VARCHAR","description":"Fund house as AMFI writes it, e.g. 'qsif SIF'."},{"name":"scheme_type","type":"VARCHAR","description":"'Open Ended Schemes' or 'Interval Fund Schemes', as filed."},{"name":"category","type":"VARCHAR","description":"AMFI's full category string, as filed."},{"name":"category_sub","type":"VARCHAR","description":"The SEBI investment strategy on its own, e.g. 'Equity Long-Short Fund'. Derived."},{"name":"category_group_clean","type":"VARCHAR","description":"'Equity Scheme', 'Debt Scheme' or 'Hybrid Scheme', same words as the MF data. Derived."},{"name":"category_group","type":"VARCHAR","description":"The first half of category, as filed."},{"name":"scheme_plan","type":"VARCHAR","description":"Direct or Regular. Derived from the scheme name; see temp_plan_basis."},{"name":"scheme_option","type":"VARCHAR","description":"Growth or IDCW. Derived from the scheme name."},{"name":"first_date","type":"DATE","description":"First date this scheme has a NAV here."},{"name":"last_date","type":"DATE","description":"Most recent date this scheme has a NAV."},{"name":"is_active","type":"BOOLEAN","description":"True if the scheme has a NAV within the last 45 days (true/false in CSV, boolean in Parquet)."},{"name":"is_stale","type":"BOOLEAN","description":"Always false; kept so the shape matches the MF scheme master."},{"name":"txic_code","type":"INTEGER","description":"Always blank; TIGZIG scheme codes are not minted for SIF."},{"name":"aaum_cr_quarterly_avg","type":"DOUBLE","description":"Quarterly AVERAGE AUM, in Rs crore (aaum_lakhs / 100). Same name as the MF scheme master."},{"name":"aaum_quarter","type":"VARCHAR","description":"The quarter of the AUM figure, named by its end month, e.g. 'June-2026'."},{"name":"aaum_quarter_end","type":"DATE","description":"That quarter's end date."},{"name":"nav_date","type":"DATE","description":"Date of the latest NAV."},{"name":"nav","type":"DOUBLE","description":"The NAV as filed (latest NAV in the scheme master)."},{"name":"source","type":"VARCHAR","description":"Always 'SIF'. Tells the rows apart when stacked with the MF data."},{"name":"temp_sif_code","type":"VARCHAR","description":"Display form 'SIF-120'. TEMPORARY: goes away when SIF merges into the MF data."},{"name":"temp_plan_basis","type":"VARCHAR","description":"'stated' = AMFI named the plan; 'sibling_complement' = inferred. TEMPORARY."},{"name":"temp_idcw_mode","type":"VARCHAR","description":"Payout, Reinvestment or Both, for IDCW schemes. Derived. TEMPORARY."},{"name":"temp_idcw_freq","type":"VARCHAR","description":"Monthly, Quarterly, Half Yearly or Annual where the name says so. TEMPORARY."},{"name":"temp_n_nav_days","type":"INTEGER","description":"Number of days this scheme has a NAV for. Computed. TEMPORARY."}],"files":[{"format":"csv","role":"data","url":"https://api.tigzig.com/downloads/sif_meta.csv","size_bytes":49465,"sha256":"51313499923355a02038d8c7b2735cd9e2c902029c394d13dab85815c87df4e0","row_count":132,"generated_at":"2026-10-24T23:40:19+00:00"},{"format":"parquet","role":"data","url":"https://api.tigzig.com/downloads/sif_meta.parquet","size_bytes":11397,"sha256":"20d5395183c023dd0d604c99728f6a97ee888017a1acfe794341573cdd23f81d","row_count":132,"generated_at":"2026-10-24T23:40:19+00:00","http_range_requests":true}],"app":"sif","parity":{"status":"ok","checked_at":"2026-10-24T06:27:11Z","detail":"sif_meta: csv = parquet, 132 rows"}}]}