Datasets

Database Documentation

Access comprehensive financial and market data through our database. Below you'll find table schemas, key fields, and example queries to get you started.

Quick Example

-- Get top performing stocks by revenue growth
SELECT 
    symbol,
    companyName,
    revenue,
    revenueGrowth
FROM annual_income_statement 
JOIN profile USING (symbol)
WHERE revenueGrowth > 0.20
    AND date >= '2023-01-01'
ORDER BY revenueGrowth DESC
LIMIT 5;

Balance Sheet

Assets, liabilities, and shareholders' equity at a specific point in time.

Tables

annual_balance_sheetquarter_balance_sheet

Key Fields (55)

symboldatereportedCurrencycikfillingDateacceptedDatecalendarYearperiodcashAndCashEquivalentsshortTermInvestmentscashAndShortTermInvestmentsnetReceivables

Example Query

SELECT 
    symbol,
    date,
    totalAssets,
    totalLiabilities,
    totalStockholdersEquity,
    cashAndCashEquivalents,
    totalCurrentAssets
FROM annual_balance_sheet
WHERE date >= '2023-01-01'
    AND symbol IN ('AAPL', 'MSFT', 'GOOGL')
ORDER BY symbol, date DESC;

Income Statement

Revenue, expenses, and profit/loss over a reporting period.

Tables

annual_income_statementquarter_income_statement

Key Fields (39)

datesymbolreportedCurrencycikfillingDateacceptedDatecalendarYearperiodrevenuecostOfRevenuegrossProfitgrossProfitRatio

Example Query

SELECT 
    symbol,
    date,
    revenue,
    netIncome,
    grossProfit,
    operatingIncome,
    EPS
FROM annual_income_statement
WHERE date >= '2023-01-01'
    AND revenue > 1000000000
ORDER BY revenue DESC;

Cash Flow Statement

Cash receipts and payments from operating, investing, and financing activities.

Tables

annual_cash_flowquarter_cash_flow

Key Fields (41)

datesymbolreportedCurrencycikfillingDateacceptedDatecalendarYearperiodnetIncomedepreciationAndAmortizationdeferredIncomeTaxstockBasedCompensation

Example Query

SELECT 
    symbol,
    date,
    netCashProvidedByOperatingActivities,
    netCashUsedForInvestingActivities,
    netCashUsedProvidedByFinancingActivities,
    freeCashFlow
FROM annual_cash_flow
WHERE date >= '2023-01-01'
    AND freeCashFlow > 0
ORDER BY freeCashFlow DESC;

Financial Growth

Year-over-year and quarter-over-quarter growth metrics and ratios.

Tables

annual_financial_growthquarter_financial_growth

Key Fields (39)

symboldateperiodrevenueGrowthgrossProfitGrowthEBITGrowthoperatingIncomeGrowthnetIncomeGrowthEPSGrowthEPSDilutedGrowthweightedAverageSharesGrowthweightedAverageSharesDilutedGrowth

Example Query

SELECT 
    symbol,
    date,
    revenueGrowth,
    netIncomeGrowth,
    operatingCashFlowGrowth,
    fiveYRevenueGrowthPerShare
FROM annual_financial_growth
WHERE date >= '2023-01-01'
    AND revenueGrowth > 0.10
ORDER BY revenueGrowth DESC;

Profile

Company information, industry classification, and basic business details.

Tables

profile

Key Fields (38)

symbolpricemarketCapbetalastDivrangechangechangePercentagevolumevolAvgcompanyNamecurrency

Example Query

SELECT 
    symbol,
    companyName,
    sector,
    industry,
    marketCap,
    fullTimeEmployees
FROM profile
WHERE sector = 'Technology'
    AND isActivelyTrading = true
ORDER BY marketCap DESC;

Key Metrics

Important financial ratios, valuation metrics, and performance indicators.

Tables

key_metrics_ttmannual_key_metricsquarter_key_metrics

Key Fields (62)

symbolrevenuePerShareTTMnetIncomePerShareTTMoperatingCashFlowPerShareTTMfreeCashFlowPerShareTTMcashPerShareTTMbookValuePerShareTTMtangibleBookValuePerShareTTMshareholdersEquityPerShareTTMinterestDebtPerShareTTMmarketCapTTMenterpriseValueTTM

Example Query

SELECT 
    symbol,
    peRatioTTM,
    pbRatioTTM,
    roeTTM,
    debtToEquityTTM,
    dividendYieldTTM
FROM key_metrics_ttm
WHERE peRatioTTM > 0
    AND peRatioTTM < 50
ORDER BY roeTTM DESC;