Name: S&P 500 Stock Prices
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

S&P 500 Stock Prices

Context

Stock market data can be interesting to analyze, strong predictive models can have large financial payoff. The amount of financial data on the web is seemingly endless. A large and well structured dataset on a wide array of companies can be hard to come by. Here I view a dataset with historical stock prices for all companies on the S&P 500 index.

Content

All the files have the following columns:

Date - in format: yy-mm-dd

Open - price of the stock at market open (this is NYSE data so all in USD)

High - highest price reached in the day

Low - lowest price reached in the day

Close - close price

Volume - number of shares traded

Acknowledgements

Thanks to Kaggle, Github, yahoo finance.

Purpose of creating the dataset

This dataset lends itself to a some very interesting visualizations. One can look at simple things like how prices change over time, graph an compare multiple stocks at once, or generate and graph new metrics from the data provided.
From these data informative stock stats such as volatility and moving averages can be easily calculated.
And people can build quantitative models such as: build portfoio, predict volatility, arbitrage, trading strategies.

Tables

Ppg

@kaggle.artemburenok_sp_500_stock_prices.ppg

410.37 kB
10,779 rows
7 columns

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

Ppl

@kaggle.artemburenok_sp_500_stock_prices.ppl

360.5 kB
10,779 rows
7 columns

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

Pru

@kaggle.artemburenok_sp_500_stock_prices.pru

244.37 kB
5,287 rows
7 columns

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

Psa

@kaggle.artemburenok_sp_500_stock_prices.psa

380.04 kB
10,608 rows
7 columns

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

Psx

@kaggle.artemburenok_sp_500_stock_prices.psx

130.23 kB
2,687 rows
7 columns

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

Ptc

@kaggle.artemburenok_sp_500_stock_prices.ptc

316.84 kB
8,318 rows
7 columns

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

Pwr

@kaggle.artemburenok_sp_500_stock_prices.pwr

248.85 kB
6,251 rows
7 columns

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

Pxd

@kaggle.artemburenok_sp_500_stock_prices.pxd

294.44 kB
6,380 rows
7 columns

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

Pypl

@kaggle.artemburenok_sp_500_stock_prices.pypl

97.33 kB
1,876 rows
7 columns

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

Qcom

@kaggle.artemburenok_sp_500_stock_prices.qcom

340.61 kB
7,809 rows
7 columns

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

Qrvo

@kaggle.artemburenok_sp_500_stock_prices.qrvo

101.01 kB
2,002 rows
7 columns

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

Rcl

@kaggle.artemburenok_sp_500_stock_prices.rcl

315.32 kB
7,463 rows
7 columns

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

Re

@kaggle.artemburenok_sp_500_stock_prices.re

299.28 kB
6,848 rows
7 columns

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

Reg

@kaggle.artemburenok_sp_500_stock_prices.reg

276.21 kB
7,334 rows
7 columns

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

Regn

@kaggle.artemburenok_sp_500_stock_prices.regn

315.23 kB
7,988 rows
7 columns

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

Rf

@kaggle.artemburenok_sp_500_stock_prices.rf

358.38 kB
10,779 rows
7 columns

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

Rhi

@kaggle.artemburenok_sp_500_stock_prices.rhi

368.84 kB
10,779 rows
7 columns

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

Rjf

@kaggle.artemburenok_sp_500_stock_prices.rjf

378.71 kB
9,946 rows
7 columns

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

Rl

@kaggle.artemburenok_sp_500_stock_prices.rl

290.05 kB
6,420 rows
7 columns

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

Rmd

@kaggle.artemburenok_sp_500_stock_prices.rmd

301.7 kB
6,933 rows
7 columns

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

Rok

@kaggle.artemburenok_sp_500_stock_prices.rok

401.83 kB
10,326 rows
7 columns

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

Rol

@kaggle.artemburenok_sp_500_stock_prices.rol

374.37 kB
10,779 rows
7 columns

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

Rop

@kaggle.artemburenok_sp_500_stock_prices.rop

330.01 kB
7,767 rows
7 columns

CREATE TABLE rop (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Rost

@kaggle.artemburenok_sp_500_stock_prices.rost

375.36 kB
9,414 rows
7 columns

CREATE TABLE rost (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Rsg

@kaggle.artemburenok_sp_500_stock_prices.rsg

263.25 kB
6,155 rows
7 columns

CREATE TABLE rsg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);