lake.stock_industries dataset schema

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.

No matching rows. Clear the filter to see all records.

Current logical schema for lake.stock_industries

Coverage and timing

One row per ticker. Identity fields plus one BOOLEAN per industry tag (e.g. technology, semiconductor, biotechnology). Tags are nullable, so negate with `technology IS NOT TRUE`, never `NOT technology`.

Tag names are singular and do not always match how a user phrases them. There is no `bank` or `banks` column — banking is `financialServices`. Other frequent mappings: semiconductors/chip stocks are `semiconductor`, airlines is `airline`, EV is `electricVehicle`, AI stocks is `artificialIntelligence`, crypto stocks is `cryptocurrency`, cloud is `cloudComputing`. There is no `name` or `description` column here. For a display name use `sec_quarterly_financials.name`, `index_constituents.componentName`, or `international_stock.name`. For GICS-style `sector` / `industry` strings use `index_constituents` — no SEC financials table carries them.

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", "name"
FROM lake.stock_industries
LIMIT 20;