Name: Yahoo Finance All Stocks (Daily Update 163 Days)
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Yahoo Finance All Stocks (Daily Update 163 Days)

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:

Date: The date of the trading day.
Open: The opening price of the stock for that day.
Close: The closing price of the stock for that day.
High: The highest price the stock reached during that day.
Low: The lowest price the stock reached during that day.
Volume: The number of shares of that stock that were traded during that day.
Dividend: Any dividends paid out on that day.
Stock Split: Any stock splits that occurred on that day.

Each row in the file represents one day of trading for that stock.

Tables

Bxp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.bxp

339.7 kB
6,609 rows
8 columns

CREATE TABLE bxp (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

C

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.c

559.98 kB
11,781 rows
8 columns

CREATE TABLE c (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cag

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cag

521.57 kB
10,972 rows
8 columns

CREATE TABLE cag (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cah

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cah

476.52 kB
10,116 rows
8 columns

CREATE TABLE cah (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Carr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.carr

50.47 kB
884 rows
8 columns

CREATE TABLE carr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cat

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cat

734.18 kB
15,537 rows
8 columns

CREATE TABLE cat (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cb

389.85 kB
7,679 rows
8 columns

CREATE TABLE cb (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cboe

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cboe

170.06 kB
3,341 rows
8 columns

CREATE TABLE cboe (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cbre

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cbre

192.18 kB
4,854 rows
8 columns

CREATE TABLE cbre (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cci

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cci

322.89 kB
6,315 rows
8 columns

CREATE TABLE cci (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ccl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ccl

448.34 kB
9,113 rows
8 columns

CREATE TABLE ccl (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cday

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cday

63.25 kB
1,361 rows
8 columns

CREATE TABLE cday (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cdns

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cdns

291.98 kB
9,144 rows
8 columns

CREATE TABLE cdns (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cdw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cdw

136.81 kB
2,577 rows
8 columns

CREATE TABLE cdw (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ce

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ce

247.66 kB
4,699 rows
8 columns

CREATE TABLE ce (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ceg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ceg

27.14 kB
421 rows
8 columns

CREATE TABLE ceg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cf

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cf

243.37 kB
4,559 rows
8 columns

CREATE TABLE cf (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cfg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cfg

122.17 kB
2,264 rows
8 columns

CREATE TABLE cfg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Chd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.chd

464.01 kB
10,972 rows
8 columns

CREATE TABLE chd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Chrw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.chrw

337.58 kB
6,525 rows
8 columns

CREATE TABLE chrw (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Chtr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.chtr

152.36 kB
3,452 rows
8 columns

CREATE TABLE chtr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ci

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ci

526.99 kB
10,457 rows
8 columns

CREATE TABLE ci (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cinf

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cinf

488.79 kB
10,972 rows
8 columns

CREATE TABLE cinf (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Cl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.cl

604.31 kB
12,709 rows
8 columns

CREATE TABLE cl (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Clx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.clx

554.11 kB
12,758 rows
8 columns

CREATE TABLE clx (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);