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

Rol

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rol

470.74 kB
10,972 rows
8 columns

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

Rop

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rop

387.87 kB
7,960 rows
8 columns

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

Rost

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rost

448.69 kB
9,607 rows
8 columns

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

Rsg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rsg

324.19 kB
6,348 rows
8 columns

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

Rtx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rtx

739.2 kB
15,474 rows
8 columns

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

Rvty

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.rvty

551.38 kB
12,758 rows
8 columns

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

Sbac

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sbac

311.53 kB
6,107 rows
8 columns

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

Sbux

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sbux

397.47 kB
7,867 rows
8 columns

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

Schw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.schw

462.06 kB
9,072 rows
8 columns

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

Sedg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sedg

93.16 kB
2,138 rows
8 columns

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

See

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.see

482.79 kB
10,972 rows
8 columns

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

Shw

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.shw

510.23 kB
10,972 rows
8 columns

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

Sjm

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sjm

339.16 kB
7,274 rows
8 columns

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

Slb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.slb

541.37 kB
10,519 rows
8 columns

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

Sna

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sna

534.21 kB
12,758 rows
8 columns

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

Snps

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.snps

274.77 kB
7,952 rows
8 columns

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

So

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.so

496.82 kB
10,519 rows
8 columns

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

Spg

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.spg

377.43 kB
7,496 rows
8 columns

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

Spgi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.spgi

564.03 kB
12,758 rows
8 columns

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

Sre

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.sre

328.78 kB
6,350 rows
8 columns

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

Ste

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ste

372.14 kB
7,886 rows
8 columns

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

Stld

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.stld

340.07 kB
6,751 rows
8 columns

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

Stt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.stt

516.16 kB
10,972 rows
8 columns

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

Stx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.stx

277.27 kB
5,230 rows
8 columns

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

Stz

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.stz

374.13 kB
7,938 rows
8 columns

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