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

Czr

@kaggle.rprkh15_sp500_stock_prices.czr

82.32 kB
1,965 rows
8 columns

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

D

@kaggle.rprkh15_sp500_stock_prices.d

490.79 kB
10,671 rows
8 columns

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

Dal

@kaggle.rprkh15_sp500_stock_prices.dal

196.8 kB
3,825 rows
8 columns

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

Dd

@kaggle.rprkh15_sp500_stock_prices.dd

634.04 kB
12,637 rows
8 columns

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

De

@kaggle.rprkh15_sp500_stock_prices.de

622.47 kB
12,637 rows
8 columns

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

Dfs

@kaggle.rprkh15_sp500_stock_prices.dfs

199.91 kB
3,796 rows
8 columns

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

Dg

@kaggle.rprkh15_sp500_stock_prices.dg

167.55 kB
3,185 rows
8 columns

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

Dgx

@kaggle.rprkh15_sp500_stock_prices.dgx

324.19 kB
6,434 rows
8 columns

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

Dhi

@kaggle.rprkh15_sp500_stock_prices.dhi

372.67 kB
7,581 rows
8 columns

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

Dhr

@kaggle.rprkh15_sp500_stock_prices.dhr

461.87 kB
10,977 rows
8 columns

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

Dis

@kaggle.rprkh15_sp500_stock_prices.dis

729.28 kB
15,236 rows
8 columns

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

Dish

@kaggle.rprkh15_sp500_stock_prices.dish

315.88 kB
6,812 rows
8 columns

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

Dlr

@kaggle.rprkh15_sp500_stock_prices.dlr

234.22 kB
4,455 rows
8 columns

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

Dltr

@kaggle.rprkh15_sp500_stock_prices.dltr

265.96 kB
6,886 rows
8 columns

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

Dov

@kaggle.rprkh15_sp500_stock_prices.dov

507 kB
10,671 rows
8 columns

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

Dow

@kaggle.rprkh15_sp500_stock_prices.dow

47.74 kB
835 rows
8 columns

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

Dpz

@kaggle.rprkh15_sp500_stock_prices.dpz

233.67 kB
4,532 rows
8 columns

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

Dre

@kaggle.rprkh15_sp500_stock_prices.dre

400.41 kB
9,181 rows
8 columns

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

Dri

@kaggle.rprkh15_sp500_stock_prices.dri

343.12 kB
6,842 rows
8 columns

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

Dte

@kaggle.rprkh15_sp500_stock_prices.dte

614.88 kB
15,236 rows
8 columns

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

Duk

@kaggle.rprkh15_sp500_stock_prices.duk

499.46 kB
10,671 rows
8 columns

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

Dva

@kaggle.rprkh15_sp500_stock_prices.dva

254.52 kB
6,720 rows
8 columns

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

Dvn

@kaggle.rprkh15_sp500_stock_prices.dvn

415.57 kB
9,319 rows
8 columns

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

Dxc

@kaggle.rprkh15_sp500_stock_prices.dxc

469.66 kB
10,218 rows
8 columns

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

Dxcm

@kaggle.rprkh15_sp500_stock_prices.dxcm

171.86 kB
4,341 rows
8 columns

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