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

400.75 KB
10779 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

352.05 KB
10779 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

238.64 KB
5287 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

371.13 KB
10608 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

127.18 KB
2687 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

309.42 KB
8318 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

243.02 KB
6251 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

287.54 KB
6380 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

95.05 KB
1876 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

332.63 KB
7809 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

98.64 KB
2002 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

307.93 KB
7463 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

292.27 KB
6848 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

269.73 KB
7334 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

307.84 KB
7988 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

349.98 KB
10779 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

360.2 KB
10779 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

369.84 KB
9946 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

283.25 KB
6420 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

294.63 KB
6933 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

392.41 KB
10326 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

365.6 KB
10779 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

322.28 KB
7767 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

366.56 KB
9414 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

257.08 KB
6155 rows
7 columns


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