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

359.58 KB
9846 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

371.69 KB
8875 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

332.68 KB
9342 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

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

221.21 KB
5907 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

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

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

162.75 KB
3678 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

310.42 KB
8847 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

100.56 KB
2053 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

91.26 KB
1876 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

279.06 KB
7823 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

384.8 KB
10636 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

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

123.68 KB
2980 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

273.4 KB
6509 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

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

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

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

173.68 KB
4068 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

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

325.2 KB
8242 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

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

325.37 KB
7681 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

202.92 KB
4832 rows
7 columns


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