Columns and types
These columns come from the same versioned logical catalog used by the query validator and engine. They describe the fields you can query. Some historical rows have missing values; fields absent from older shards can return typed NULL.
| ticker | VARCHAR |
| symbol | VARCHAR |
| date | TIMESTAMP |
| name | VARCHAR |
| totalRevenue | DOUBLE |
| netIncome | DOUBLE |
| ebitda | DOUBLE |
| grossProfit | DOUBLE |
| freeCashFlow | DOUBLE |
| totalAssets | DOUBLE |
| totalLiab | DOUBLE |
| commonStockSharesOutstanding | DOUBLE |
| shortTermDebt | DOUBLE |
| longTermDebt | DOUBLE |
| operatingIncome | DOUBLE |
| operatingCashFlow | DOUBLE |
| capitalExpenditures | DOUBLE |
| cik | BIGINT |
| periodEnd | TIMESTAMP |
| filed | TIMESTAMP |
| availabilitySource | VARCHAR |
| source | VARCHAR |
| accession | VARCHAR |
| sourceFilingUrl | VARCHAR |
| quarterlyFlowProvenance | VARCHAR |
| revenueDerivation | VARCHAR |
| filedValueCorrections | VARCHAR |
| filedPeriodCorrection | VARCHAR |
| sharesOutstandingBasis | VARCHAR |
| sharesOutstandingAsOf | TIMESTAMP |
| currency | VARCHAR |
| periodStart | TIMESTAMP |
| taxonomy | VARCHAR |
| fiscalYear | BIGINT |
| fiscalPeriod | VARCHAR |
No matching rows. Clear the filter to see all records.
Current logical schema for lake.canonical_quarterly_financials
Coverage and timing
Point-in-time quarterly statements from SEC filings, every revision kept.
This is what the backtest engine reads, and it is the availability-dated table — so it is also the only no-lookahead-safe fundamentals source. Research a signal here or the backtest that validates it runs on different data. `date` is when the figure became PUBLICLY KNOWABLE (the filing date). `periodEnd` is the fiscal period end, and they are far apart. Filter on `date` for point-in-time correctness; filter on `periodEnd` when the user names a specific fiscal quarter or year. One row per FILING, so a restated quarter appears more than once. Collapse to the latest revision with `QUALIFY ROW_NUMBER() OVER (PARTITION BY ticker, periodEnd ORDER BY date DESC) = 1`. `revenueDerivation` records the exact inputs to constructed Q4 revenue (`annual_minus_prior_quarters`: the annual and Q1–Q3 rows; `annual_minus_nine_month_ytd`: the annual row and the nine-month year-to-date fact, used when Q1–Q3 were not all filed before the 10-K), including retained direct/composed raw fact identities. Values in this JSON remain in native reporting units even on USD canonical rows. Cash-flow revisions preserve this revenue origin; NULL on legacy shards means unknown provenance. `quarterlyFlowProvenance` carries the exact inputs for YTD-subtracted operating cash flow and capex when published by the newer exporter; older shards can have NULL until republished. Coverage starts with SEC XBRL filings in 2009; trailing-twelve-month values exist from about mid-2010. Pre-2009 vendor history is not served.
Run a limited query
Use a registered API key with lake scope. Select needed columns, bind user-supplied values and restrict dates when the table has a time dimension. Query results are durable parts with a schema and manifest rather than an unbounded in-memory array.
This reference documents the schema and its meaning. Run queries in your signed-in workspace; this page does not execute SQL or show private results and datasets.
SELECT "ticker", "symbol", "date"
FROM lake.canonical_quarterly_financials
LIMIT 20;