Yahoo Finance All Stocks (Daily Update 163 Days)
A Dataset of Historical Stock Data for Stocks Available on Yahoo Finance
@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update
A Dataset of Historical Stock Data for Stocks Available on Yahoo Finance
@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update
The Yahoo Finance API provides access to a vast dataset of historical stock prices and financial information for publicly traded companies. This dataset contains information on a wide range of stocks, including stocks from major indices such as the S&P 500 and NASDAQ, as well as smaller, less well-known companies. The data includes a variety of financial metrics, including opening and closing prices, daily high and low prices, trading volume, and more, making it a valuable resource for investors, analysts, and researchers.
The dataset contains historical stock data for all the stocks in Yahoo Finance API, the files is named after their respective stock symbols. Each file is in CSV format and will contain the following columns:
Each row in the file represents one day of trading for that stock.
CREATE TABLE isrg (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE it (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE itw (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE ivz (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE j (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jbht (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jci (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jkhy (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jnj (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jnpr (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE jpm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE k (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kdp (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE key (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE keys (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE khc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kim (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE klac (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kmb (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kmi (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kmx (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE ko (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kr (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE kvue (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE l (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE ldos (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE len (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lh (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lhx (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lin (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lkq (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lly (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lmt (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lnt (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE low (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lrcx (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE luv (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lvs (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lw (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lyb (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE lyv (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE ma (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE maa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mar (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mas (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mcd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mchp (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mck (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mco (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);CREATE TABLE mdlz (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);Anyone who has the link will be able to view this.