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

Exc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.exc

557.39 kB
12,709 rows
8 columns

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

Expd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.expd

432.86 kB
9,826 rows
8 columns

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

Expe

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.expe

239.91 kB
4,574 rows
8 columns

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

Exr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.exr

250.36 kB
4,809 rows
8 columns

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

F

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.f

649.34 kB
12,938 rows
8 columns

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

Fang

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fang

146.65 kB
2,752 rows
8 columns

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

Fast

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fast

434.67 kB
9,094 rows
8 columns

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

Fcx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fcx

365.29 kB
7,101 rows
8 columns

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

Fds

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fds

342.09 kB
6,853 rows
8 columns

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

Fdx

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fdx

534.17 kB
11,460 rows
8 columns

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

Fe

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fe

337.93 kB
6,508 rows
8 columns

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

Ffiv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ffiv

253.96 kB
6,115 rows
8 columns

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

Fi

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fi

327.56 kB
9,322 rows
8 columns

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

Fico

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fico

400.08 kB
9,115 rows
8 columns

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

Fis

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fis

293.7 kB
5,599 rows
8 columns

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

Fitb

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fitb

494.16 kB
10,972 rows
8 columns

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

Flt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.flt

140.37 kB
3,213 rows
8 columns

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

Fmc

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fmc

482.57 kB
10,972 rows
8 columns

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

Fox

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fox

63.41 kB
1,141 rows
8 columns

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

Foxa

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.foxa

63.69 kB
1,142 rows
8 columns

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

Frt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.frt

504.29 kB
12,708 rows
8 columns

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

Fslr

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.fslr

180.21 kB
4,238 rows
8 columns

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

Ftnt

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ftnt

149.18 kB
3,483 rows
8 columns

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

Ftv

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.ftv

97.91 kB
1,817 rows
8 columns

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

Gd

@kaggle.tanavbajaj_yahoo_finance_all_stocks_dataset_daily_update.gd

692.86 kB
15,537 rows
8 columns

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