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

Ecl

@kaggle.artemburenok_sp_500_stock_prices.ecl

415.67 KB
12565 rows
7 columns


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

Ed

@kaggle.artemburenok_sp_500_stock_prices.ed

463.71 KB
15344 rows
7 columns


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

Efx

@kaggle.artemburenok_sp_500_stock_prices.efx

375.62 KB
10779 rows
7 columns


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

Eix

@kaggle.artemburenok_sp_500_stock_prices.eix

405.29 KB
12515 rows
7 columns


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

El

@kaggle.artemburenok_sp_500_stock_prices.el

298.77 KB
6815 rows
7 columns


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

Elv

@kaggle.artemburenok_sp_500_stock_prices.elv

257.16 KB
5318 rows
7 columns


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

Emn

@kaggle.artemburenok_sp_500_stock_prices.emn

305.71 KB
7303 rows
7 columns


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

Emr

@kaggle.artemburenok_sp_500_stock_prices.emr

445.32 KB
12745 rows
7 columns


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

Enph

@kaggle.artemburenok_sp_500_stock_prices.enph

114.45 KB
2695 rows
7 columns


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

Eog

@kaggle.artemburenok_sp_500_stock_prices.eog

344.18 KB
8364 rows
7 columns


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

Epam

@kaggle.artemburenok_sp_500_stock_prices.epam

134.98 KB
2731 rows
7 columns


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

Eqix

@kaggle.artemburenok_sp_500_stock_prices.eqix

267.39 KB
5621 rows
7 columns


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

Eqr

@kaggle.artemburenok_sp_500_stock_prices.eqr

289.24 KB
7389 rows
7 columns


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

Eqt

@kaggle.artemburenok_sp_500_stock_prices.eqt

395.79 KB
10779 rows
7 columns


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

Es

@kaggle.artemburenok_sp_500_stock_prices.es

372.54 KB
12565 rows
7 columns


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

Ess

@kaggle.artemburenok_sp_500_stock_prices.ess

301.15 KB
7183 rows
7 columns


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

Etn

@kaggle.artemburenok_sp_500_stock_prices.etn

468.81 KB
12745 rows
7 columns


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

Etr

@kaggle.artemburenok_sp_500_stock_prices.etr

402.01 KB
12745 rows
7 columns


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

Etsy

@kaggle.artemburenok_sp_500_stock_prices.etsy

96.01 KB
1931 rows
7 columns


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

Evrg

@kaggle.artemburenok_sp_500_stock_prices.evrg

366.61 KB
12565 rows
7 columns


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

Ew

@kaggle.artemburenok_sp_500_stock_prices.ew

266.52 KB
5717 rows
7 columns


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

Exc

@kaggle.artemburenok_sp_500_stock_prices.exc

404.48 KB
12516 rows
7 columns


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

Expd

@kaggle.artemburenok_sp_500_stock_prices.expd

348.88 KB
9633 rows
7 columns


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

Expe

@kaggle.artemburenok_sp_500_stock_prices.expe

204.21 KB
4381 rows
7 columns


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

Exr

@kaggle.artemburenok_sp_500_stock_prices.exr

207.11 KB
4616 rows
7 columns


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