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

296.88 KB
6825 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

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

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

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

71.52 KB
1540 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

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

212.21 KB
4298 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

322.76 KB
7931 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

331.77 KB
8450 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

412.64 KB
12104 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

263.44 KB
5631 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

277.91 KB
7330 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

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

321.02 KB
7495 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

67.18 KB
1478 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

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

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

120.49 KB
2418 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

67.94 KB
1408 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

271.93 KB
6764 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

275.91 KB
5660 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

288.36 KB
7352 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

432.17 KB
12551 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

251.75 KB
6874 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

360.63 KB
10779 rows
7 columns


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