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

Tsn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tsn

490.99 kB
10,972 rows
8 columns

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

Tt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tt

536.16 kB
10,971 rows
8 columns

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

Ttwo

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ttwo

294.02 kB
6,654 rows
8 columns

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

Txn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.txn

649.99 kB
12,938 rows
8 columns

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

Txt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.txt

552.92 kB
12,758 rows
8 columns

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

Tyl

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.tyl

327.12 kB
10,972 rows
8 columns

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

Ual

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ual

188.15 kB
4,437 rows
8 columns

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

Udr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.udr

438.68 kB
10,972 rows
8 columns

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

Uhs

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.uhs

444.73 kB
10,641 rows
8 columns

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

Ulta

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ulta

191.57 kB
4,004 rows
8 columns

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

Unh

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.unh

471.49 kB
9,811 rows
8 columns

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

Unp

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.unp

563.37 kB
11,024 rows
8 columns

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

Ups

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ups

315.51 kB
6,004 rows
8 columns

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

Uri

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.uri

326.79 kB
6,481 rows
8 columns

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

Usb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.usb

511.6 kB
12,708 rows
8 columns

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

V

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.v

207.47 kB
3,905 rows
8 columns

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

Vfc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vfc

520.82 kB
10,972 rows
8 columns

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

Vici

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vici

78.61 kB
1,440 rows
8 columns

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

Vlo

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vlo

501.74 kB
10,518 rows
8 columns

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

Vmc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vmc

533.19 kB
12,758 rows
8 columns

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

Vrsk

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vrsk

181.24 kB
3,513 rows
8 columns

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

Vrsn

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vrsn

312.27 kB
6,453 rows
8 columns

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

Vrtx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vrtx

290.91 kB
8,102 rows
8 columns

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

Vtr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vtr

336.24 kB
6,640 rows
8 columns

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

Vtrs

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.vtrs

497.91 kB
10,972 rows
8 columns

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