Data Tables for Yahoo Finance

Data Tables for Yahoo Finance

The download package contains the preconfigured project to download market data.

It includes the SQL code, mssql-create-database.sql, to create an MS SQL database to import loaded CSV data.

You may edit the file to change the table structures described below.

All the tables are created in the schema named 'yahoo'.

Tips: You may leave the default tables as is and load data using the preconfigured project, and then import data from the default tables to your tables.

Tables

TableDescription
yahoo.DividendsContains dividends.
yahoo.HistoricalPricesContains historical prices.
yahoo.IndustriesContains industries.
yahoo.KeyStatisticsContains key statistic data.
yahoo.OptionContractsContains option contracts.
yahoo.OptionsContains option chain data.
yahoo.OptionTypesContains option types.
yahoo.QuotesContains quotes.

yahoo.Dividends

ColumnDataTypeNullableKeyComment
Symbolvarchar(50)NOT NULLPK
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULLPK
DatedateNOT NULLPK
Dividendsfloat

Data provider: Yahoo Finance Dividends

yahoo.HistoricalPrices

ColumnDataTypeNullableKeyComment
Symbolvarchar(50)NOT NULLPK
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULLPK
DatedateNOT NULLPK
Opensmallmoney
Highsmallmoney
Lowsmallmoney
Closesmallmoney
Volumebigint
AdjClosesmallmoney
RunningSplitKfloat
OpenKsmallmoney
HighKsmallmoney
LowKsmallmoney
CloseKsmallmoney

Data provider: Yahoo Finance Historical Prices

yahoo.Industries

ColumnDataTypeNullableKeyComment
Symbolvarchar(50)NOT NULLPK
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULL
Sectorvarchar(50)
Industryvarchar(50)

Data provider: Yahoo Finance Industries

yahoo.KeyStatistics

ColumnDataTypeNullableKeyComment
Symbolvarchar(50)NOT NULLPK
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULLPK
MarketDatedate
MarketTimetime
MarketCapFormattedvarchar(50)
MarketCapbigint
EnterpriseValueFormattedvarchar(50)
EnterpriseValuebigint
EnterpriseValueDatedate
TrailingPEfloat
ForwardPEfloat
ForwardPEDatedate
PEGfloat
PriceSalesfloat
PriceBookfloat
EnterpriseValueToRevenuefloat
EnterpriseValueToEBITDAfloat
FiscalYearEndsvarchar(50)
MostRecentQuarterdate
ProfitMarginfloat
OperatingMarginfloat
ReturnOnAssetsfloat
ReturnOnEquityfloat
RevenueFormattedvarchar(50)
Revenuebigint
RevenuePerSharefloat
QuartelyRevenueGrowthfloat
GrossProfitFormattedvarchar(50)
GrossProfitbigint
EBITDAFormattedvarchar(50)
EBITDAbigint
NetIncomeAvlToCommonFormattedvarchar(50)
NetIncomeAvlToCommonfloat
DilutedEPSfloat
QuarterlyEarningsGrowthfloat
TotalCashFormattedvarchar(50)
TotalCashbigint
TotalCashPerSharefloat
TotalDebtFormattedvarchar(50)
TotalDebtbigint
TotalDebtToEquityfloat
CurrentRatiofloat
BookValuePerSharefloat
OperatingCashFlowFormattedvarchar(50)
OperatingCashFlowbigint
LeveredFreeCashFlowFormattedvarchar(50)
LeveredFreeCashFlowbigint
Betafloat
Week52Changefloat
Week52ChangeSP500float
Week52Highsmallmoney
Week52Lowsmallmoney
Week52HighDatedate
Week52LowDatedate
DMA50smallmoney
DMA200smallmoney
AverageVolume3Monthsbigint
AverageVolume10Daysbigint
SharesOutstandingFormattedvarchar(50)
SharesOutstandingbigint
FloatSharesFormattedvarchar(50)
FloatSharesbigint
PercentHeldByInsidersfloat
PercentHeldByInstitutionsfloat
SharesShortFormattedvarchar(50)
SharesShortbigint
SharesShortDatedate
ShortRatiofloat
ShortRatioDatedate
ShortAsPercentOfFloatfloat
ShortAsPercentOfFloatDatedate
SharesShortPriorMonthFormattedvarchar(50)
SharesShortPriorMonthbigint
ForwardAnnualDividendRatefloat
ForwardAnnualDividendYieldfloat
TrailingAnnualDividendRatefloat
TrailingAnnualDividendYieldfloat
FiveYearAverageDividendYieldfloat
PayoutRatiofloat
DividendDatedate
ExDividendDatedate
LastSplitFactorvarchar(50)
LastSplitDatedate

Data provider: Yahoo Finance Key Statistics

yahoo.Quotes

ColumnDataTypeNullableKeyComment
Symbolvarchar(50)NOT NULLPK
Namenvarchar(255)
StockExchangevarchar(50)
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULLPK
MarketDatedateNOT NULL
MarketTimetimeNOT NULL
LastTradeDatedate
LastTradeTimetime
Opensmallmoney
Highsmallmoney
Lowsmallmoney
Lastsmallmoney
Changesmallmoney
ChangeInPercentfloat
Week52Highsmallmoney
Week52Lowsmallmoney
OneYearTargetPricesmallmoney
Volumebigint
AverageDailyVolumebigint
DMA50smallmoney
DMA200smallmoney
ShortRatiofloat
EPSfloat
EPS_EstCurrentYearfloat
EPS_EstNextYearfloat
EPS_EstNextQuarterfloat
PEfloat
PE_EstCurrentYearfloat
PE_EstNextYearfloat
PEGfloat
ExDividendDatedate
DividendPayDatedate
DividendPerSharefloat
DividendYieldfloat
MarketCapvarchar(50)
MarketCapitalizationbigint
BookValuefloat
PriceBookfloat
PriceSalesfloat
FloatSharesbigint

Data provider: Yahoo Finance Quotes

yahoo.OptionTypes

ColumnDataTypeNullableIdentityKeyComment
OptionTypechar(1)NOT NULLPKContains C and P.
Typevarchar(4)NOT NULLContains CALL and PUT.

The table contains two values: C - CALL and P - PUT.

yahoo.OptionContracts

ColumnDataTypeNullableKeyComment
IDintNOT NULLPK, IDENTITY
ContractNamevarchar(50)NOT NULL
Symbolvarchar(50)NOT NULL
ExpDatedateNOT NULL
Typechar(1)NOT NULLFK
StrikesmallmoneyNOT NULL
PairContractNamevarchar(50)NOT NULLThe field is prepared by SQL code.

The table contains data about option contracts extracted from option chain data.

Data provider: Yahoo Finance Options

yahoo.Options

ColumnDataTypeNullableIdentityKeyComment
OptionContractIDintNOT NULLPK, FK
LoadDatedateNOT NULLPK
LoadTimetimeNOT NULLPK
MarketDatedate
MarketTimetime
Lastsmallmoney
Bidsmallmoney
Asksmallmoney
Changesmallmoney
ChangeInPercentfloat
Volumeint
OpenInterestint
ImpliedVolatilityfloat

Data provider: Yahoo Finance Options