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

Jbht

@kaggle.artemburenok_sp_500_stock_prices.jbht

368.21 kB
9,846 rows
7 columns

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

Jci

@kaggle.artemburenok_sp_500_stock_prices.jci

380.61 kB
8,875 rows
7 columns

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

Jkhy

@kaggle.artemburenok_sp_500_stock_prices.jkhy

340.67 kB
9,342 rows
7 columns

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

Jnj

@kaggle.artemburenok_sp_500_stock_prices.jnj

552.19 kB
15,344 rows
7 columns

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

Jnpr

@kaggle.artemburenok_sp_500_stock_prices.jnpr

226.52 kB
5,907 rows
7 columns

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

Jpm

@kaggle.artemburenok_sp_500_stock_prices.jpm

422.94 kB
10,779 rows
7 columns

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

K

@kaggle.artemburenok_sp_500_stock_prices.k

406.88 kB
12,565 rows
7 columns

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

Kdp

@kaggle.artemburenok_sp_500_stock_prices.kdp

166.66 kB
3,678 rows
7 columns

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

Key

@kaggle.artemburenok_sp_500_stock_prices.key

317.87 kB
8,847 rows
7 columns

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

Keys

@kaggle.artemburenok_sp_500_stock_prices.keys

102.97 kB
2,053 rows
7 columns

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

Khc

@kaggle.artemburenok_sp_500_stock_prices.khc

93.45 kB
1,876 rows
7 columns

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

Kim

@kaggle.artemburenok_sp_500_stock_prices.kim

285.75 kB
7,823 rows
7 columns

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

Klac

@kaggle.artemburenok_sp_500_stock_prices.klac

394.04 kB
10,636 rows
7 columns

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

Kmb

@kaggle.artemburenok_sp_500_stock_prices.kmb

421.57 kB
10,779 rows
7 columns

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

Kmi

@kaggle.artemburenok_sp_500_stock_prices.kmi

126.65 kB
2,980 rows
7 columns

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

Kmx

@kaggle.artemburenok_sp_500_stock_prices.kmx

279.97 kB
6,509 rows
7 columns

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

Ko

@kaggle.artemburenok_sp_500_stock_prices.ko

537.35 kB
15,344 rows
7 columns

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

Kr

@kaggle.artemburenok_sp_500_stock_prices.kr

473.62 kB
15,344 rows
7 columns

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

L

@kaggle.artemburenok_sp_500_stock_prices.l

395.83 kB
10,779 rows
7 columns

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

Ldos

@kaggle.artemburenok_sp_500_stock_prices.ldos

177.85 kB
4,068 rows
7 columns

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

Len

@kaggle.artemburenok_sp_500_stock_prices.len

400.42 kB
10,779 rows
7 columns

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

Lh

@kaggle.artemburenok_sp_500_stock_prices.lh

333 kB
8,242 rows
7 columns

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

Lhx

@kaggle.artemburenok_sp_500_stock_prices.lhx

406.46 kB
10,326 rows
7 columns

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

Lin

@kaggle.artemburenok_sp_500_stock_prices.lin

333.18 kB
7,681 rows
7 columns

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

Lkq

@kaggle.artemburenok_sp_500_stock_prices.lkq

207.78 kB
4,832 rows
7 columns

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