fetch
Retrieve any financial field from any source as point-in-time rows, using as-of dates to see exactly what was public on a given day. Covers fundamentals, prices, factors, and more.
Instructions
Fetch any field from any source, as point-in-time rows.
Field forms: "us-gaap:Assets" (needs entity), "price:close" (needs entity), "fred:CPIAUCSL", "french:ff3", "openap:Mom12m" (or "openap:*" for all 331 published claims), "crypto:close" (needs an entity like BTC-USD), "short:short_ratio" (needs an entity), "ape:all-stocks", "13f:value" (needs a manager like BERKSHIRE), "bls:CUUR0000SA0", "bea:T10101". Run discover first if unsure.
as_of is the point-in-time switch: it drops every row that was not
public on that date, so you see what a researcher on that day saw,
restatements and all. quarter picks a reporting period for 13F
holdings ("2024-12-31" or "2024"); without it you get the latest.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end | No | ||
| form | No | ||
| as_of | No | ||
| field | Yes | ||
| limit | No | ||
| start | No | ||
| entity | No | ||
| quarter | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |