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

Pnw

@kaggle.rprkh15_sp500_stock_prices.pnw

489.18 kB
12,457 rows
8 columns

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

Pool

@kaggle.rprkh15_sp500_stock_prices.pool

326.13 kB
6,732 rows
8 columns

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

Ppg

@kaggle.rprkh15_sp500_stock_prices.ppg

516.01 kB
10,671 rows
8 columns

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

Ppl

@kaggle.rprkh15_sp500_stock_prices.ppl

471.08 kB
10,671 rows
8 columns

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

Pru

@kaggle.rprkh15_sp500_stock_prices.pru

272.24 kB
5,179 rows
8 columns

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

Psa

@kaggle.rprkh15_sp500_stock_prices.psa

435.24 kB
10,500 rows
8 columns

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

Psx

@kaggle.rprkh15_sp500_stock_prices.psx

137.88 kB
2,579 rows
8 columns

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

Ptc

@kaggle.rprkh15_sp500_stock_prices.ptc

275.54 kB
8,210 rows
8 columns

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

Pvh

@kaggle.rprkh15_sp500_stock_prices.pvh

466.41 kB
10,671 rows
8 columns

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

Pwr

@kaggle.rprkh15_sp500_stock_prices.pwr

304.97 kB
6,143 rows
8 columns

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

Pxd

@kaggle.rprkh15_sp500_stock_prices.pxd

321.04 kB
6,272 rows
8 columns

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

Pypl

@kaggle.rprkh15_sp500_stock_prices.pypl

80.98 kB
1,768 rows
8 columns

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

Qcom

@kaggle.rprkh15_sp500_stock_prices.qcom

394.45 kB
7,701 rows
8 columns

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

Qrvo

@kaggle.rprkh15_sp500_stock_prices.qrvo

84.06 kB
1,894 rows
8 columns

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

Rcl

@kaggle.rprkh15_sp500_stock_prices.rcl

369.57 kB
7,355 rows
8 columns

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

Re

@kaggle.rprkh15_sp500_stock_prices.re

337.05 kB
6,740 rows
8 columns

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

Reg

@kaggle.rprkh15_sp500_stock_prices.reg

346.6 kB
7,226 rows
8 columns

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

Regn

@kaggle.rprkh15_sp500_stock_prices.regn

271.21 kB
7,880 rows
8 columns

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

Rf

@kaggle.rprkh15_sp500_stock_prices.rf

468.39 kB
10,671 rows
8 columns

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

Rhi

@kaggle.rprkh15_sp500_stock_prices.rhi

436.71 kB
10,671 rows
8 columns

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

Rjf

@kaggle.rprkh15_sp500_stock_prices.rjf

446.97 kB
9,838 rows
8 columns

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

Rl

@kaggle.rprkh15_sp500_stock_prices.rl

320.14 kB
6,312 rows
8 columns

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

Rmd

@kaggle.rprkh15_sp500_stock_prices.rmd

331.04 kB
6,825 rows
8 columns

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

Rok

@kaggle.rprkh15_sp500_stock_prices.rok

496.08 kB
10,218 rows
8 columns

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

Rol

@kaggle.rprkh15_sp500_stock_prices.rol

455.39 kB
10,671 rows
8 columns

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