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

Hsic

@kaggle.artemburenok_sp_500_stock_prices.hsic

304.01 kB
6,825 rows
7 columns

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

Hst

@kaggle.artemburenok_sp_500_stock_prices.hst

366.88 kB
10,779 rows
7 columns

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

Hsy

@kaggle.artemburenok_sp_500_stock_prices.hsy

401.4 kB
10,779 rows
7 columns

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

Hum

@kaggle.artemburenok_sp_500_stock_prices.hum

403.72 kB
10,326 rows
7 columns

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

Hwm

@kaggle.artemburenok_sp_500_stock_prices.hwm

73.23 kB
1,540 rows
7 columns

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

Ibm

@kaggle.artemburenok_sp_500_stock_prices.ibm

615.88 kB
15,344 rows
7 columns

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

Ice

@kaggle.artemburenok_sp_500_stock_prices.ice

217.3 kB
4,298 rows
7 columns

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

Idxx

@kaggle.artemburenok_sp_500_stock_prices.idxx

330.5 kB
7,931 rows
7 columns

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

Iex

@kaggle.artemburenok_sp_500_stock_prices.iex

339.73 kB
8,450 rows
7 columns

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

Iff

@kaggle.artemburenok_sp_500_stock_prices.iff

422.54 kB
12,104 rows
7 columns

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

Ilmn

@kaggle.artemburenok_sp_500_stock_prices.ilmn

269.76 kB
5,631 rows
7 columns

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

Incy

@kaggle.artemburenok_sp_500_stock_prices.incy

284.57 kB
7,330 rows
7 columns

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

Intc

@kaggle.artemburenok_sp_500_stock_prices.intc

409.09 kB
10,779 rows
7 columns

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

Intu

@kaggle.artemburenok_sp_500_stock_prices.intu

328.73 kB
7,495 rows
7 columns

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

Invh

@kaggle.artemburenok_sp_500_stock_prices.invh

68.79 kB
1,478 rows
7 columns

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

Ip

@kaggle.artemburenok_sp_500_stock_prices.ip

519.2 kB
15,344 rows
7 columns

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

Ipg

@kaggle.artemburenok_sp_500_stock_prices.ipg

355.03 kB
10,779 rows
7 columns

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

Iqv

@kaggle.artemburenok_sp_500_stock_prices.iqv

123.39 kB
2,418 rows
7 columns

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

Ir

@kaggle.artemburenok_sp_500_stock_prices.ir

69.57 kB
1,408 rows
7 columns

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

Irm

@kaggle.artemburenok_sp_500_stock_prices.irm

278.46 kB
6,764 rows
7 columns

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

Isrg

@kaggle.artemburenok_sp_500_stock_prices.isrg

282.53 kB
5,660 rows
7 columns

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

It

@kaggle.artemburenok_sp_500_stock_prices.it

295.28 kB
7,352 rows
7 columns

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

Itw

@kaggle.artemburenok_sp_500_stock_prices.itw

442.55 kB
12,551 rows
7 columns

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

Ivz

@kaggle.artemburenok_sp_500_stock_prices.ivz

257.79 kB
6,874 rows
7 columns

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

J

@kaggle.artemburenok_sp_500_stock_prices.j

369.28 kB
10,779 rows
7 columns

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