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

Oke

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.oke

485.74 kB
10,833 rows
8 columns

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

Omc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.omc

484.26 kB
10,972 rows
8 columns

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

On

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.on

192.74 kB
5,885 rows
8 columns

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

Orcl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.orcl

471.88 kB
9,459 rows
8 columns

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

Orly

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.orly

283.67 kB
7,659 rows
8 columns

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

Otis

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.otis

50.29 kB
884 rows
8 columns

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

Oxy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.oxy

514.18 kB
10,519 rows
8 columns

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

Panw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.panw

128.06 kB
2,811 rows
8 columns

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

Para

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.para

239.04 kB
4,479 rows
8 columns

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

Payc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.payc

126.3 kB
2,376 rows
8 columns

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

Payx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.payx

470.65 kB
10,100 rows
8 columns

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

Pcar

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pcar

502.74 kB
10,972 rows
8 columns

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

Pcg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pcg

562.08 kB
12,938 rows
8 columns

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

Peak

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.peak

452.23 kB
9,660 rows
8 columns

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

Peg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.peg

521.61 kB
11,024 rows
8 columns

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

Pep

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pep

626.19 kB
12,938 rows
8 columns

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

Pfe

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pfe

627.8 kB
12,938 rows
8 columns

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

Pfg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pfg

288.54 kB
5,516 rows
8 columns

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

Pg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pg

743.75 kB
15,537 rows
8 columns

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

Pgr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pgr

507.33 kB
10,972 rows
8 columns

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

Ph

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ph

514.94 kB
10,972 rows
8 columns

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

Phm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.phm

504.4 kB
10,972 rows
8 columns

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

Pkg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pkg

303.76 kB
5,950 rows
8 columns

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

Pld

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pld

331.93 kB
6,499 rows
8 columns

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

Pm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.pm

206.13 kB
3,907 rows
8 columns

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