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

Vz

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vz

515.61 kB
10,039 rows
8 columns

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

Wab

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wab

352.86 kB
7,116 rows
8 columns

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

Wat

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wat

273.19 kB
7,008 rows
8 columns

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

Wba

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wba

527.28 kB
10,972 rows
8 columns

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

Wbd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wbd

180.06 kB
4,583 rows
8 columns

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

Wdc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wdc

444.69 kB
11,319 rows
8 columns

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

Wec

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wec

490.53 kB
10,972 rows
8 columns

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

Well

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.well

450.35 kB
10,970 rows
8 columns

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

Wfc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wfc

596.77 kB
12,938 rows
8 columns

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

Whr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.whr

563.88 kB
12,758 rows
8 columns

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

Wm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wm

401.85 kB
8,882 rows
8 columns

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

Wmb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wmb

525 kB
10,519 rows
8 columns

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

Wmt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wmt

627.11 kB
12,878 rows
8 columns

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

Wrb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wrb

514.61 kB
12,588 rows
8 columns

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

Wrk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wrk

111.83 kB
2,076 rows
8 columns

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

Wst

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wst

453.77 kB
10,972 rows
8 columns

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

Wtw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wtw

291.98 kB
5,605 rows
8 columns

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

Wy

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wy

616.87 kB
12,708 rows
8 columns

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

Wynn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.wynn

278.3 kB
5,262 rows
8 columns

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

Xel

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.xel

530.82 kB
12,758 rows
8 columns

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

Xom

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.xom

743.87 kB
15,537 rows
8 columns

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

Xray

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.xray

423.93 kB
9,100 rows
8 columns

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

Xyl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.xyl

158.46 kB
3,004 rows
8 columns

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

Yum

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.yum

340.06 kB
6,546 rows
8 columns

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

Zbh

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.zbh

290 kB
5,575 rows
8 columns

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