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

Gl

@kaggle.artemburenok_sp_500_stock_prices.gl

393.49 kB
10,641 rows
7 columns

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

Glw

@kaggle.artemburenok_sp_500_stock_prices.glw

375.29 kB
10,326 rows
7 columns

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

Gm

@kaggle.artemburenok_sp_500_stock_prices.gm

132.19 kB
3,038 rows
7 columns

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

Gnrc

@kaggle.artemburenok_sp_500_stock_prices.gnrc

154.57 kB
3,233 rows
7 columns

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

Goog

@kaggle.artemburenok_sp_500_stock_prices.goog

250.02 kB
4,613 rows
7 columns

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

Googl

@kaggle.artemburenok_sp_500_stock_prices.googl

249.56 kB
4,613 rows
7 columns

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

Gpc

@kaggle.artemburenok_sp_500_stock_prices.gpc

391.08 kB
10,779 rows
7 columns

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

Gpn

@kaggle.artemburenok_sp_500_stock_prices.gpn

261.22 kB
5,514 rows
7 columns

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

Grmn

@kaggle.artemburenok_sp_500_stock_prices.grmn

257.57 kB
5,538 rows
7 columns

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

Gs

@kaggle.artemburenok_sp_500_stock_prices.gs

290.26 kB
5,944 rows
7 columns

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

Gww

@kaggle.artemburenok_sp_500_stock_prices.gww

443.32 kB
12,565 rows
7 columns

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

Hal

@kaggle.artemburenok_sp_500_stock_prices.hal

472.02 kB
12,745 rows
7 columns

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

Has

@kaggle.artemburenok_sp_500_stock_prices.has

402.04 kB
10,779 rows
7 columns

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

Hban

@kaggle.artemburenok_sp_500_stock_prices.hban

348.84 kB
10,779 rows
7 columns

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

Hca

@kaggle.artemburenok_sp_500_stock_prices.hca

150.04 kB
2,962 rows
7 columns

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

Hd

@kaggle.artemburenok_sp_500_stock_prices.hd

428.71 kB
10,396 rows
7 columns

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

Hes

@kaggle.artemburenok_sp_500_stock_prices.hes

405.29 kB
10,779 rows
7 columns

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

Hig

@kaggle.artemburenok_sp_500_stock_prices.hig

298.38 kB
6,796 rows
7 columns

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

Hii

@kaggle.artemburenok_sp_500_stock_prices.hii

148.8 kB
2,954 rows
7 columns

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

Hlt

@kaggle.artemburenok_sp_500_stock_prices.hlt

112.48 kB
2,267 rows
7 columns

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

Holx

@kaggle.artemburenok_sp_500_stock_prices.holx

306.88 kB
8,262 rows
7 columns

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

Hon

@kaggle.artemburenok_sp_500_stock_prices.hon

541.28 kB
15,344 rows
7 columns

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

Hpe

@kaggle.artemburenok_sp_500_stock_prices.hpe

80.41 kB
1,802 rows
7 columns

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

Hpq

@kaggle.artemburenok_sp_500_stock_prices.hpq

570.88 kB
15,344 rows
7 columns

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

Hrl

@kaggle.artemburenok_sp_500_stock_prices.hrl

366.83 kB
10,779 rows
7 columns

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