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

A

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.a

312.88 kB
5,998 rows
8 columns

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

Aal

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aal

230.86 kB
4,527 rows
8 columns

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

Aapl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aapl

542.52 kB
10,784 rows
8 columns

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

Abbv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.abbv

145.09 kB
2,699 rows
8 columns

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

Abnb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.abnb

36.27 kB
699 rows
8 columns

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

Abt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.abt

549.76 kB
10,972 rows
8 columns

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

Acgl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.acgl

259.28 kB
7,054 rows
8 columns

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

Acn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.acn

291.25 kB
5,579 rows
8 columns

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

Adbe

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.adbe

424.22 kB
9,352 rows
8 columns

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

Adi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.adi

492.68 kB
10,972 rows
8 columns

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

Adm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.adm

531.3 kB
10,972 rows
8 columns

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

Adp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.adp

539.2 kB
10,972 rows
8 columns

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

Adsk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.adsk

424.9 kB
9,635 rows
8 columns

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

Aee

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aee

334.18 kB
6,472 rows
8 columns

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

Aep

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aep

663.61 kB
15,537 rows
8 columns

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

Aes

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aes

393.45 kB
8,121 rows
8 columns

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

Afl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.afl

517.97 kB
10,972 rows
8 columns

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

Aig

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aig

582.91 kB
12,792 rows
8 columns

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

Aiz

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.aiz

257.15 kB
4,941 rows
8 columns

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

Ajg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ajg

447.44 kB
9,894 rows
8 columns

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

Akam

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.akam

239.79 kB
6,012 rows
8 columns

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

Alb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.alb

369.5 kB
7,448 rows
8 columns

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

Algn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.algn

225.6 kB
5,697 rows
8 columns

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

Alk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.alk

474.47 kB
10,972 rows
8 columns

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

All

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.all

391.81 kB
7,631 rows
8 columns

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