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

384.27 KB
10641 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

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

129.1 KB
3038 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

150.95 KB
3233 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

244.16 KB
4613 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

243.71 KB
4613 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

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

255.1 KB
5514 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

251.53 KB
5538 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

283.46 KB
5944 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

432.93 KB
12565 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

460.96 KB
12745 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

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

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

146.52 KB
2962 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

418.66 KB
10396 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

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

291.39 KB
6796 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

145.32 KB
2954 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

109.84 KB
2267 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

299.69 KB
8262 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

528.6 KB
15344 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

78.52 KB
1802 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

557.5 KB
15344 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

358.23 KB
10779 rows
7 columns


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