Name: S&P500 Stock Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P500 Stock Prices

Context

The Standard and Poor's 500 is a stock market index tracking the performance of 500 large companies listed on stock exchanges in the United States. It is one of the most commonly followed equity indices. As of December 31, 2020, more than $5.4 trillion was invested in assets tied to the performance of the index.

Inspiration

This dataset can be used to create some interesting visualizations and identify how stock prices of a particular company vary over time. Working with stock data is one of the best ways to get acquainted with timeseries forecasting. Can you create a model to stay one step ahead of the market and make statistically informed trading decisions?

Content

The naming convention of the files are in the form ticker.csv. The individual files contain the historical stock price data of that company. All the files have the following columns:

Date: The date is in the format yy-mm-dd
Open: Price of the stock when the market opens
High: Highest price reached in the day
Low: Lowest price reached in the day
Close: Price of the stock when the market closes
Volume: Number of shares traded in a day
Dividends: The dividends of the stock
Stock Splits: The stock splits of the company. In a stock split, a company divides its existing stock into multiple shares to boost liquidity.

Acknowledgement

Credits to Yahoo Finance that simplified the process of scraping stock data.

Tables

Exr

@kaggle.rprkh15_sp500_stock_prices.exr

234.56 kB
4,508 rows
8 columns

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

F

@kaggle.rprkh15_sp500_stock_prices.f

632.65 kB
12,637 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.rprkh15_sp500_stock_prices.fang

131 kB
2,451 rows
8 columns

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

Fast

@kaggle.rprkh15_sp500_stock_prices.fast

413.93 kB
8,793 rows
8 columns

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

Fbhs

@kaggle.rprkh15_sp500_stock_prices.fbhs

144.21 kB
2,722 rows
8 columns

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

Fcx

@kaggle.rprkh15_sp500_stock_prices.fcx

349 kB
6,800 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.rprkh15_sp500_stock_prices.fds

326.99 kB
6,553 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.rprkh15_sp500_stock_prices.fdx

516.7 kB
11,159 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.rprkh15_sp500_stock_prices.fe

321.91 kB
6,207 rows
8 columns

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

Ffiv

@kaggle.rprkh15_sp500_stock_prices.ffiv

241.82 kB
5,814 rows
8 columns

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

Fis

@kaggle.rprkh15_sp500_stock_prices.fis

277.61 kB
5,298 rows
8 columns

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

Fisv

@kaggle.rprkh15_sp500_stock_prices.fisv

314.99 kB
9,021 rows
8 columns

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

Fitb

@kaggle.rprkh15_sp500_stock_prices.fitb

475.79 kB
10,671 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.rprkh15_sp500_stock_prices.flt

127.74 kB
2,912 rows
8 columns

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

Fmc

@kaggle.rprkh15_sp500_stock_prices.fmc

467.47 kB
10,671 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.rprkh15_sp500_stock_prices.fox

47.32 kB
840 rows
8 columns

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

Foxa

@kaggle.rprkh15_sp500_stock_prices.foxa

47.68 kB
841 rows
8 columns

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

Frc

@kaggle.rprkh15_sp500_stock_prices.frc

153.39 kB
2,916 rows
8 columns

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

Frt

@kaggle.rprkh15_sp500_stock_prices.frt

488.24 kB
12,407 rows
8 columns

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

Ftnt

@kaggle.rprkh15_sp500_stock_prices.ftnt

135.9 kB
3,182 rows
8 columns

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

Ftv

@kaggle.rprkh15_sp500_stock_prices.ftv

82.46 kB
1,516 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.rprkh15_sp500_stock_prices.gd

675.41 kB
15,236 rows
8 columns

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

Ge

@kaggle.rprkh15_sp500_stock_prices.ge

756.29 kB
15,236 rows
8 columns

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

Gild

@kaggle.rprkh15_sp500_stock_prices.gild

374.55 kB
7,675 rows
8 columns

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

Gis

@kaggle.rprkh15_sp500_stock_prices.gis

525.54 kB
10,671 rows
8 columns

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