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

Swk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.swk

505.49 kB
10,972 rows
8 columns

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

Swks

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.swks

408.78 kB
9,839 rows
8 columns

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

Syf

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.syf

123.55 kB
2,302 rows
8 columns

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

Syk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.syk

484.48 kB
10,972 rows
8 columns

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

Syy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.syy

528.93 kB
12,705 rows
8 columns

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

T

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.t

512.72 kB
10,040 rows
8 columns

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

Tap

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tap

507.9 kB
12,175 rows
8 columns

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

Tdg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tdg

227.52 kB
4,411 rows
8 columns

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

Tdy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tdy

228.89 kB
5,995 rows
8 columns

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

Tech

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tech

373.83 kB
8,721 rows
8 columns

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

Tel

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tel

215.27 kB
4,097 rows
8 columns

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

Ter

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ter

511.68 kB
12,758 rows
8 columns

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

Tfc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tfc

463.3 kB
10,971 rows
8 columns

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

Tfx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tfx

483.91 kB
10,972 rows
8 columns

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

Tgt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tgt

593.11 kB
12,758 rows
8 columns

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

Tjx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tjx

464.16 kB
9,132 rows
8 columns

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

Tmo

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tmo

489.44 kB
10,972 rows
8 columns

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

Tmus

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tmus

200.84 kB
4,136 rows
8 columns

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

Tpr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tpr

303.35 kB
5,775 rows
8 columns

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

Trgp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.trgp

170.34 kB
3,219 rows
8 columns

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

Trmb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.trmb

286.21 kB
8,357 rows
8 columns

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

Trow

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.trow

454.5 kB
9,445 rows
8 columns

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

Trv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.trv

532.37 kB
12,065 rows
8 columns

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

Tsco

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tsco

347.37 kB
7,450 rows
8 columns

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

Tsla

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tsla

153.04 kB
3,331 rows
8 columns

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