query_fundamentals
Retrieve point-in-time financial statement items as of a required date, preventing look-ahead bias and returning the vintage current then; page results with limit/offset.
Instructions
Financial statement items, point-in-time. as_of is REQUIRED and is what prevents look-ahead: only figures publicly announced on or before that date come back, and a restated figure returns the vintage that was current then. For a present-day view pass today's date; for a historical study pass the date being studied, never today. Results are paged with limit/offset. For prices use query_bars; for valuation ratios read valuation_metrics through query_dataset. Set pit_mode='strict' only to audit what the lake itself held on that date.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| as_of | Yes | YYYY-MM-DD knowledge cutoff, applied to announce_date. | |
| items | No | item_code filter, e.g. ['roe', 'net_profit']. | |
| limit | No | Max rows to return (default 200, cap 2000). Responses always report the true total and set `truncated`. | |
| offset | No | Rows to skip, for paging with `limit`. | |
| symbols | No | Symbols as '<code>.<EX>', e.g. ['600519.SH', '000001.SZ']. Omit for every symbol in range. Use resolve_symbol to turn a company name into a code. | |
| pit_mode | No | best_effort (default) also returns rows a later backfill recorded, flagged pit_is_exact=false; strict keeps only rows the lake held by as_of, which is none for a backfilled history. | |
| all_vintages | No | Return every vintage announced by as_of instead of only the one current then. For studying restatements; it double-counts a fact in any cross-sectional screen. |