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 |
| filed | TIMESTAMP |
| periodEnd | TIMESTAMP |
| availabilitySource | VARCHAR |
| cik | BIGINT |
| accession | VARCHAR |
| rawArchiveKey | VARCHAR |
| rawSha256 | VARCHAR |
| sourceFilingUrl | VARCHAR |
| quarterlyFlowProvenance | VARCHAR |
| revenueDerivation | VARCHAR |
| filedValueCorrections | VARCHAR |
| filedPeriodCorrection | VARCHAR |
| reportingCurrency | VARCHAR |
| periodStart | TIMESTAMP |
| taxonomy | VARCHAR |
| fiscalYear | BIGINT |
| fiscalPeriod | VARCHAR |
No matching rows. Clear the filter to see all records.
Current logical schema for lake.sec_quarterly_financials
Coverage and timing
Native-currency SEC XBRL quarterly statements. Prefer `canonical_quarterly_financials` for USD comparisons and backtest parity. `date` carries the saved availability timestamp; inspect `availabilitySource` and filing provenance for its basis.
SEC XBRL quarterly fundamentals. The row key includes `accession`, so one period can appear more than once — a restatement is a second row, not an update. Collapse to the latest revision before any TTM, CAGR, or per-period aggregate: `QUALIFY ROW_NUMBER() OVER (PARTITION BY ticker, cast(periodEnd as date) ORDER BY filed DESC, date DESC) = 1`. Partition by `cast(date as date)` instead when `periodEnd` is null. `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` is JSON for YTD-subtracted operating cash flow or capex, including both SEC input facts and their filing identities. A later revision also records its original base filing. It does not yet describe FY-minus-prior-quarters Q4 synthesis. NULL on an older shard does not establish that a flow was directly reported. Fiscal labels and interval metadata can be NULL on older shards. `reportingCurrency` identifies the native monetary unit; use canonical statements for USD comparisons. Has no `sector` or `industry` column. Use `year(cast(date as date))` for an availability calendar year, `stock_industries` for boolean theme tags, and `index_constituents` for GICS-style sector and industry strings.
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.sec_quarterly_financials
LIMIT 20;