Market-data lake

lake.stockindustries dataset schema

Column types and research semantics for NexusTrade’s lake.stockindustries dataset. Read the supported schema before submitting a bounded SQL query.

Query name
lake.stockindustries
Grain
snapshot
Columns
130

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.

tickerVARCHAR
symbolVARCHAR
nameVARCHAR
descriptionVARCHAR
3dPrintingBOOLEAN
advertisingBOOLEAN
aerospaceBOOLEAN
agricultureBOOLEAN
airlineBOOLEAN
alternativeEnergyBOOLEAN
analyticsBOOLEAN
artBOOLEAN
artificialIntelligenceBOOLEAN
augmentedRealityBOOLEAN
autoInsuranceBOOLEAN
automotiveBOOLEAN
autonomousTransportationBOOLEAN
batteryTechnologyBOOLEAN
bioinformaticsBOOLEAN
biotechnologyBOOLEAN
blockchainBOOLEAN
cannabisBOOLEAN
cleanEnergyBOOLEAN
clothesAndApparalBOOLEAN
cloudComputingBOOLEAN
computationalBiologyBOOLEAN
computationalChemistryBOOLEAN
constructionBOOLEAN
consumerElectronicsBOOLEAN
consumerGoodsBOOLEAN
cruiseBOOLEAN
cryptocurrencyBOOLEAN
customerEngagementBOOLEAN
cybersecurityBOOLEAN
dataVisualizationBOOLEAN
databaseBOOLEAN
defenseBOOLEAN
digitalHealthBOOLEAN
digitalMarketplaceBOOLEAN
digitalSignatureAndAuthenticationBOOLEAN
ecommerceBOOLEAN
edtechBOOLEAN
educationBOOLEAN
electricVehicleBOOLEAN
energyBOOLEAN
enterpriseSoftwareBOOLEAN
entertainmentAndMediaBOOLEAN
fashionAndApparelBOOLEAN
financialServicesBOOLEAN
foodAndBeverageBOOLEAN
foodDeliveryBOOLEAN
forestryBOOLEAN
frackingBOOLEAN
gamblingBOOLEAN
gamingBOOLEAN
gasBOOLEAN
goldBOOLEAN
graphicDesignBOOLEAN
graphicsCardBOOLEAN
hardwareBOOLEAN
healthInsuranceBOOLEAN
healthcareBOOLEAN
homeInsuranceBOOLEAN
homeSecurityBOOLEAN
hospitalityAndTravelBOOLEAN
immunotherapyBOOLEAN
informationTechnologyBOOLEAN
investingBOOLEAN
iotBOOLEAN
jewelryBOOLEAN
lifeInsuranceBOOLEAN
logisticsAndSupplyChainBOOLEAN
luxuryGoodsBOOLEAN
manufacturingBOOLEAN
materialScienceBOOLEAN
medicalDevicesBOOLEAN
medicineBOOLEAN
messagingBOOLEAN
miningAndNaturalResourcesBOOLEAN
mobileApplicationBOOLEAN
moviesBOOLEAN
musicAndAudioBOOLEAN
nanotechnologyBOOLEAN
nutritionBOOLEAN
oilBOOLEAN
oncologyBOOLEAN
outdoorAndRecreationalEquipmentBOOLEAN
paymentsBOOLEAN
personalAndHouseholdGoodsBOOLEAN
petCareBOOLEAN
pharmaceuticalsBOOLEAN
phonesBOOLEAN
printingBOOLEAN
productivityToolsBOOLEAN
publishingBOOLEAN
quantumComputingBOOLEAN
realEstateBOOLEAN
recreationalVehicleBOOLEAN
renewableEnergyBOOLEAN
researchBOOLEAN
retailBOOLEAN
rideShareBOOLEAN
roboticsBOOLEAN
saasBOOLEAN
securityBOOLEAN
semiconductorBOOLEAN
silverBOOLEAN
smartDevicesBOOLEAN
socialMediaBOOLEAN
socialNetworkBOOLEAN
softwareBOOLEAN
solarEnergyBOOLEAN
spaceExplorationBOOLEAN
sportsAndFitnessBOOLEAN
sportsBettingBOOLEAN
streamingBOOLEAN
technologyBOOLEAN
telecommunicationsBOOLEAN
transportationBOOLEAN
utilitiesBOOLEAN
vaccinesBOOLEAN
veterinaryBOOLEAN
videoConferencingBOOLEAN
videosBOOLEAN
virtualRealityBOOLEAN
wasteManagementAndRecyclingBOOLEAN
waterPurifactionBOOLEAN
waterTreatmentBOOLEAN
wearableBOOLEAN
windEnergyBOOLEAN

Current logical schema for lake.stockindustries

Coverage and timing

Alias of stock_industries.

Inspect source dates and nullable fields before interpreting a result. A completed query is not proof that the source is current, complete for every security, or public at an event’s occurrence time.

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.

sql
SELECT "ticker", "symbol", "name"
FROM lake.stockindustries
LIMIT 20;