DJIA Stocks Historical OHLCV (daily Updated)
Current Dow Jones Industrial Average Index Components Open High Low Close Volume
@kaggle.joebeachcapital_djia_stocks_historical_ohlcv_daily_updated
Current Dow Jones Industrial Average Index Components Open High Low Close Volume
@kaggle.joebeachcapital_djia_stocks_historical_ohlcv_daily_updated
Current 30 components of the Dow Jones Industrial Average, and their Open, High, Low, Close, Adjusted Close, Volume data since 1980, for stocks that were listed then. Updates daily using the Yahoo Finance API.
CREATE TABLE dow_jones_data (
"date" TIMESTAMP,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR,
"ticker" VARCHAR,
"close_1" VARCHAR,
"high_1" VARCHAR,
"low_1" VARCHAR,
"open_1" VARCHAR,
"volume_1" VARCHAR,
"close_2" VARCHAR,
"high_2" VARCHAR,
"low_2" VARCHAR,
"open_2" VARCHAR,
"volume_2" VARCHAR,
"close_3" VARCHAR,
"high_3" VARCHAR,
"low_3" VARCHAR,
"open_3" VARCHAR,
"volume_3" VARCHAR,
"close_4" VARCHAR,
"high_4" VARCHAR,
"low_4" VARCHAR,
"open_4" VARCHAR,
"volume_4" VARCHAR,
"close_5" VARCHAR,
"high_5" VARCHAR,
"low_5" VARCHAR,
"open_5" VARCHAR,
"volume_5" VARCHAR,
"close_6" VARCHAR,
"high_6" VARCHAR,
"low_6" VARCHAR,
"open_6" VARCHAR,
"volume_6" VARCHAR,
"close_7" VARCHAR,
"high_7" VARCHAR,
"low_7" VARCHAR,
"open_7" VARCHAR,
"volume_7" VARCHAR,
"close_8" VARCHAR,
"high_8" VARCHAR,
"low_8" VARCHAR,
"open_8" VARCHAR,
"volume_8" VARCHAR,
"close_9" VARCHAR,
"high_9" VARCHAR,
"low_9" VARCHAR,
"open_9" VARCHAR,
"volume_9" VARCHAR,
"close_10" VARCHAR,
"high_10" VARCHAR,
"low_10" VARCHAR,
"open_10" VARCHAR,
"volume_10" VARCHAR,
"close_11" VARCHAR,
"high_11" VARCHAR,
"low_11" VARCHAR,
"open_11" VARCHAR,
"volume_11" VARCHAR,
"close_12" VARCHAR,
"high_12" VARCHAR,
"low_12" VARCHAR,
"open_12" VARCHAR,
"volume_12" VARCHAR,
"close_13" VARCHAR,
"high_13" VARCHAR,
"low_13" VARCHAR,
"open_13" VARCHAR,
"volume_13" VARCHAR,
"close_14" VARCHAR,
"high_14" VARCHAR,
"low_14" VARCHAR,
"open_14" VARCHAR,
"volume_14" VARCHAR,
"close_15" VARCHAR,
"high_15" VARCHAR,
"low_15" VARCHAR,
"open_15" VARCHAR,
"volume_15" VARCHAR,
"close_16" VARCHAR,
"high_16" VARCHAR,
"low_16" VARCHAR,
"open_16" VARCHAR,
"volume_16" VARCHAR,
"close_17" VARCHAR,
"high_17" VARCHAR,
"low_17" VARCHAR,
"open_17" VARCHAR,
"volume_17" VARCHAR,
"close_18" VARCHAR,
"high_18" VARCHAR,
"low_18" VARCHAR,
"open_18" VARCHAR,
"volume_18" VARCHAR,
"close_19" VARCHAR,
"high_19" VARCHAR,
"low_19" VARCHAR
);Anyone who has the link will be able to view this.