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

Pnc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pnc

523.27 kB
12,065 rows
8 columns

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

Pnr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pnr

505.48 kB
12,708 rows
8 columns

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

Pnw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pnw

505.32 kB
12,758 rows
8 columns

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

Podd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.podd

166.45 kB
4,118 rows
8 columns

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

Pool

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pool

341.65 kB
7,033 rows
8 columns

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

Ppg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ppg

531.95 kB
10,972 rows
8 columns

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

Ppl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ppl

487.52 kB
10,972 rows
8 columns

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

Pru

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pru

288.23 kB
5,480 rows
8 columns

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

Psa

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.psa

451.72 kB
10,801 rows
8 columns

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

Psx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.psx

153.52 kB
2,880 rows
8 columns

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

Ptc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ptc

288.41 kB
8,511 rows
8 columns

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

Pwr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pwr

320.8 kB
6,444 rows
8 columns

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

Pxd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pxd

337.16 kB
6,573 rows
8 columns

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

Pypl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pypl

94.15 kB
2,069 rows
8 columns

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

Qcom

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.qcom

410.92 kB
8,002 rows
8 columns

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

Qrvo

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.qrvo

97.22 kB
2,195 rows
8 columns

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

Rcl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rcl

383.94 kB
7,656 rows
8 columns

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

Reg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.reg

362.48 kB
7,527 rows
8 columns

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

Regn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.regn

284.55 kB
8,181 rows
8 columns

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

Rf

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rf

487.54 kB
10,972 rows
8 columns

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

Rhi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rhi

453.96 kB
10,972 rows
8 columns

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

Rjf

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rjf

461.69 kB
10,139 rows
8 columns

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

Rl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rl

335.88 kB
6,613 rows
8 columns

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

Rmd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rmd

346.67 kB
7,126 rows
8 columns

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

Rok

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rok

513.84 kB
10,519 rows
8 columns

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