About this Dataset

Yahoo Finance Historical Prices And Ticker Fundamentals

This dataset combines daily end-of-day stock market price history with point-in-time company fundamentals and listing metadata sourced from Yahoo Finance.

Data is organized into two tables:

daily_prices: one row per (symbol, trading day) with OHLCV and basic trading metadata.
tickers_metadata: one row per symbol with the latest available company profile, listing, and fundamental metrics.

Typical use cases include factor and quant research, fundamental screening, cross-sectional comparisons across sectors and regions, and joining filings or alternative data to market prices and fundamentals via the symbol key.

Tables

Daily Prices

@yahoo.finance.daily_prices

1.58 GB
95,389,179 rows
11 columns

CREATE TABLE daily_prices (
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE,
  "currency" VARCHAR,
  "exchange_name" VARCHAR,
  "instrument_type" VARCHAR
);

Tickers Metadata

@yahoo.finance.tickers_metadata

10.06 MB
27,560 rows
65 columns

CREATE TABLE tickers_metadata (
  "symbol" VARCHAR,
  "company_short_name" VARCHAR,
  "company_long_name" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "country" VARCHAR,
  "website" VARCHAR,
  "full_time_employees" BIGINT,
  "address1" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "phone" VARCHAR,
  "long_business_summary" VARCHAR,
  "exchange" VARCHAR,
  "full_exchange_name" VARCHAR,
  "market" VARCHAR,
  "language" VARCHAR,
  "region" VARCHAR,
  "exchange_timezone_name" VARCHAR,
  "exchange_timezone_short_name" VARCHAR,
  "gmt_offset_milliseconds" BIGINT,
  "first_trade_date" TIMESTAMP,
  "market_cap" DOUBLE,
  "enterprise_value" DOUBLE,
  "trailing_pe" DOUBLE,
  "forward_pe" DOUBLE,
  "beta" DOUBLE,
  "price_to_book" DOUBLE,
  "price_to_sales_ttm" DOUBLE,
  "trailing_eps" DOUBLE,
  "forward_eps" DOUBLE,
  "eps_current_year" DOUBLE,
  "profit_margins" DOUBLE,
  "gross_margins" DOUBLE,
  "operating_margins" DOUBLE,
  "ebitda_margins" DOUBLE,
  "revenue_growth" DOUBLE,
  "return_on_assets" DOUBLE,
  "total_revenue" DOUBLE,
  "revenue_per_share" DOUBLE,
  "gross_profits" DOUBLE,
  "ebitda" DOUBLE,
  "total_cash" DOUBLE,
  "total_debt" DOUBLE,
  "total_cash_per_share" DOUBLE,
  "free_cashflow" DOUBLE,
  "operating_cashflow" DOUBLE,
  "shares_outstanding" DOUBLE,
  "float_shares" DOUBLE,
  "implied_shares_outstanding" DOUBLE,
  "shares_short" DOUBLE,
  "shares_short_prior_month" DOUBLE,
  "shares_percent_shares_out" DOUBLE,
  "short_ratio" DOUBLE,
  "short_percent_of_float" DOUBLE,
  "held_percent_insiders" DOUBLE,
  "held_percent_institutions" DOUBLE,
  "trailing_annual_dividend_rate" DOUBLE,
  "trailing_annual_dividend_yield" DOUBLE,
  "five_year_avg_dividend_yield" DOUBLE,
  "last_dividend_value" DOUBLE,
  "last_dividend_date" TIMESTAMP,
  "ex_dividend_date" TIMESTAMP,
  "dividend_date" TIMESTAMP
);