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

Cag

@kaggle.rprkh15_sp500_stock_prices.cag

505.56 kB
10,671 rows
8 columns

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

Cah

@kaggle.rprkh15_sp500_stock_prices.cah

459.1 kB
9,815 rows
8 columns

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

Carr

@kaggle.rprkh15_sp500_stock_prices.carr

35.3 kB
583 rows
8 columns

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

Cat

@kaggle.rprkh15_sp500_stock_prices.cat

718.14 kB
15,236 rows
8 columns

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

Cb

@kaggle.rprkh15_sp500_stock_prices.cb

373.95 kB
7,378 rows
8 columns

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

Cboe

@kaggle.rprkh15_sp500_stock_prices.cboe

156.13 kB
3,040 rows
8 columns

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

Cbre

@kaggle.rprkh15_sp500_stock_prices.cbre

179.45 kB
4,553 rows
8 columns

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

Cci

@kaggle.rprkh15_sp500_stock_prices.cci

306.77 kB
6,014 rows
8 columns

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

Ccl

@kaggle.rprkh15_sp500_stock_prices.ccl

435.29 kB
8,812 rows
8 columns

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

Cday

@kaggle.rprkh15_sp500_stock_prices.cday

50.35 kB
1,060 rows
8 columns

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

Cdns

@kaggle.rprkh15_sp500_stock_prices.cdns

273.79 kB
8,843 rows
8 columns

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

Cdw

@kaggle.rprkh15_sp500_stock_prices.cdw

121.39 kB
2,276 rows
8 columns

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

Ce

@kaggle.rprkh15_sp500_stock_prices.ce

231.27 kB
4,398 rows
8 columns

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

Ceg

@kaggle.rprkh15_sp500_stock_prices.ceg

11.84 kB
120 rows
8 columns

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

Cf

@kaggle.rprkh15_sp500_stock_prices.cf

226.94 kB
4,258 rows
8 columns

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

Cfg

@kaggle.rprkh15_sp500_stock_prices.cfg

105.02 kB
1,963 rows
8 columns

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

Chd

@kaggle.rprkh15_sp500_stock_prices.chd

445.62 kB
10,671 rows
8 columns

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

Chrw

@kaggle.rprkh15_sp500_stock_prices.chrw

321.65 kB
6,224 rows
8 columns

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

Chtr

@kaggle.rprkh15_sp500_stock_prices.chtr

139.14 kB
3,151 rows
8 columns

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

Ci

@kaggle.rprkh15_sp500_stock_prices.ci

511.74 kB
10,156 rows
8 columns

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

Cinf

@kaggle.rprkh15_sp500_stock_prices.cinf

472.76 kB
10,671 rows
8 columns

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

Cl

@kaggle.rprkh15_sp500_stock_prices.cl

589.21 kB
12,408 rows
8 columns

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

Clx

@kaggle.rprkh15_sp500_stock_prices.clx

537.24 kB
12,457 rows
8 columns

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

Cma

@kaggle.rprkh15_sp500_stock_prices.cma

476.24 kB
10,671 rows
8 columns

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

Cmcsa

@kaggle.rprkh15_sp500_stock_prices.cmcsa

491.06 kB
10,671 rows
8 columns

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