live parquet · no backend

37.5 million fund prices.
A few byte ranges.

Pick an Indian mutual fund. LakeQL will find its complete NAV history inside a 170 MB Parquet file, straight from this browser.

choose a fund

Search 38,000+ schemes

Fund name or AMFI code

Example funds

NAV history

Parag Parikh Flexi Cap Fund — Direct Growth

Loading the live Parquet file…

querying

Reading row-group metadata…

latest NAV—

history—

NAV change—

observations—

what crossed the wire

Range reads, measured.

— fetched from a 170.3 MB file

HTTP requests: —
full downloads: —
file avoided: —
wall time: —

executed in this tab

lake.path("amfi_nav_master.parquet")
  .where(eq("scheme_code", 122639))
  .select(["date", "nav", "scheme_name"])
  .orderBy([{ column: "date" }])
  .toArray()

rows returned

The latest observations

Open TigZig source ↗

Date	NAV	AMFI scheme code
—	—	122639

The dataset stays remote.

LakeQL reads Parquet metadata first, prunes by scheme code, then requests only the selected column chunks.

The decimal stays accurate.

NAV is stored as INT64 DECIMAL(18,4). LakeQL checks every unscaled value before converting it to JavaScript.

The numbers are public.

TigZig republishes AMFI records under CC0 and keeps matured schemes, which avoids survivorship-only histories.