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

Ldos

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ldos

219.6 kB
4,261 rows
8 columns

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

Len

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.len

495.1 kB
10,972 rows
8 columns

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

Lh

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lh

385.88 kB
8,435 rows
8 columns

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

Lhx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lhx

520.27 kB
10,519 rows
8 columns

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

Lin

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lin

396.98 kB
7,874 rows
8 columns

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

Lkq

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lkq

254.71 kB
5,025 rows
8 columns

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

Lly

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lly

645.12 kB
12,938 rows
8 columns

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

Lmt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lmt

581.73 kB
11,781 rows
8 columns

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

Lnt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lnt

499.34 kB
12,758 rows
8 columns

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

Low

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.low

524.36 kB
10,972 rows
8 columns

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

Lrcx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lrcx

440.92 kB
9,926 rows
8 columns

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

Luv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.luv

549.28 kB
11,024 rows
8 columns

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

Lvs

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lvs

251.22 kB
4,724 rows
8 columns

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

Lw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lw

93.08 kB
1,726 rows
8 columns

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

Lyb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lyb

178.98 kB
3,374 rows
8 columns

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

Lyv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.lyv

171.4 kB
4,467 rows
8 columns

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

Ma

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ma

233.79 kB
4,361 rows
8 columns

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

Maa

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.maa

355.98 kB
7,464 rows
8 columns

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

Mar

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mar

337.5 kB
6,418 rows
8 columns

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

Mas

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mas

531.09 kB
10,972 rows
8 columns

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

Mcd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mcd

698.12 kB
14,402 rows
8 columns

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

Mchp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mchp

393.97 kB
7,683 rows
8 columns

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

Mck

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mck

374.9 kB
7,266 rows
8 columns

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

Mco

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mco

347.06 kB
7,274 rows
8 columns

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

Mdlz

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.mdlz

295.59 kB
5,604 rows
8 columns

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