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

Alle

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.alle

131.57 kB
2,477 rows
8 columns

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

Amat

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amat

500.8 kB
10,972 rows
8 columns

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

Amcr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amcr

90 kB
2,857 rows
8 columns

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

Amd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amd

323.51 kB
10,972 rows
8 columns

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

Ame

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ame

455.37 kB
9,874 rows
8 columns

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

Amgn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amgn

490.35 kB
10,149 rows
8 columns

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

Amp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amp

240.14 kB
4,535 rows
8 columns

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

Amt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amt

330.06 kB
6,434 rows
8 columns

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

Amzn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.amzn

296.7 kB
6,632 rows
8 columns

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

Anet

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.anet

106.56 kB
2,340 rows
8 columns

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

Anss

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.anss

260.32 kB
6,860 rows
8 columns

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

Aon

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aon

511.95 kB
10,919 rows
8 columns

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

Aos

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aos

459.78 kB
10,076 rows
8 columns

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

Apa

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.apa

534.56 kB
11,184 rows
8 columns

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

Apd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.apd

535.25 kB
10,972 rows
8 columns

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

Aph

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aph

383.1 kB
8,026 rows
8 columns

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

Aptv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aptv

156.58 kB
2,979 rows
8 columns

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

Are

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.are

333.85 kB
6,624 rows
8 columns

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

Ato

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ato

430.21 kB
10,015 rows
8 columns

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

Atvi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.atvi

360.05 kB
7,531 rows
8 columns

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

Avb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.avb

359.49 kB
7,435 rows
8 columns

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

Avgo

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.avgo

188.04 kB
3,556 rows
8 columns

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

Avy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.avy

538.21 kB
12,758 rows
8 columns

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

Awk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.awk

201.13 kB
3,881 rows
8 columns

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

Axon

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.axon

208.29 kB
5,600 rows
8 columns

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