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

Isrg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.isrg

253.24 kB
5,853 rows
8 columns

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

It

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.it

290.8 kB
7,545 rows
8 columns

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

Itw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.itw

543.21 kB
12,744 rows
8 columns

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

Ivz

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ivz

357.09 kB
7,067 rows
8 columns

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

J

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.j

437.74 kB
10,972 rows
8 columns

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

Jbht

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jbht

451.93 kB
10,039 rows
8 columns

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

Jci

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jci

471.56 kB
9,068 rows
8 columns

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

Jkhy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jkhy

418.85 kB
9,535 rows
8 columns

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

Jnj

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jnj

745.61 kB
15,537 rows
8 columns

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

Jnpr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jnpr

314.39 kB
6,100 rows
8 columns

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

Jpm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.jpm

549.17 kB
10,972 rows
8 columns

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

K

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.k

557.86 kB
12,758 rows
8 columns

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

Kdp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kdp

202.63 kB
3,871 rows
8 columns

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

Key

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.key

456.87 kB
9,040 rows
8 columns

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

Keys

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.keys

98.92 kB
2,246 rows
8 columns

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

Khc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.khc

112.05 kB
2,069 rows
8 columns

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

Kim

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kim

391.74 kB
8,016 rows
8 columns

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

Klac

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.klac

471.64 kB
10,829 rows
8 columns

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

Kmb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kmb

537.75 kB
10,972 rows
8 columns

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

Kmi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kmi

168.26 kB
3,173 rows
8 columns

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

Kmx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kmx

253.35 kB
6,702 rows
8 columns

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

Ko

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ko

763.66 kB
15,537 rows
8 columns

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

Kr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kr

662.1 kB
15,537 rows
8 columns

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

Kvue

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.kvue

10.94 kB
97 rows
8 columns

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

L

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.l

525.47 kB
10,972 rows
8 columns

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