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

Lly

@kaggle.artemburenok_sp_500_stock_prices.lly

471.66 kB
12,745 rows
7 columns

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

Lmt

@kaggle.artemburenok_sp_500_stock_prices.lmt

459.87 kB
11,588 rows
7 columns

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

Lnc

@kaggle.artemburenok_sp_500_stock_prices.lnc

384.04 kB
10,779 rows
7 columns

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

Lnt

@kaggle.artemburenok_sp_500_stock_prices.lnt

381.3 kB
12,565 rows
7 columns

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

Low

@kaggle.artemburenok_sp_500_stock_prices.low

408.89 kB
10,779 rows
7 columns

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

Lrcx

@kaggle.artemburenok_sp_500_stock_prices.lrcx

374.84 kB
9,733 rows
7 columns

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

Lumn

@kaggle.artemburenok_sp_500_stock_prices.lumn

359.18 kB
10,779 rows
7 columns

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

Luv

@kaggle.artemburenok_sp_500_stock_prices.luv

403.54 kB
10,831 rows
7 columns

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

Lvs

@kaggle.artemburenok_sp_500_stock_prices.lvs

210.42 kB
4,531 rows
7 columns

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

Lw

@kaggle.artemburenok_sp_500_stock_prices.lw

78.16 kB
1,533 rows
7 columns

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

Lyb

@kaggle.artemburenok_sp_500_stock_prices.lyb

155.38 kB
3,181 rows
7 columns

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

Lyv

@kaggle.artemburenok_sp_500_stock_prices.lyv

186.05 kB
4,274 rows
7 columns

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

Ma

@kaggle.artemburenok_sp_500_stock_prices.ma

216.57 kB
4,168 rows
7 columns

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

Maa

@kaggle.artemburenok_sp_500_stock_prices.maa

291.31 kB
7,271 rows
7 columns

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

Mar

@kaggle.artemburenok_sp_500_stock_prices.mar

300.81 kB
6,225 rows
7 columns

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

Mas

@kaggle.artemburenok_sp_500_stock_prices.mas

392.25 kB
10,779 rows
7 columns

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

Mcd

@kaggle.artemburenok_sp_500_stock_prices.mcd

531.28 kB
14,209 rows
7 columns

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

Mchp

@kaggle.artemburenok_sp_500_stock_prices.mchp

325.21 kB
7,490 rows
7 columns

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

Mck

@kaggle.artemburenok_sp_500_stock_prices.mck

319.73 kB
7,073 rows
7 columns

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

Mco

@kaggle.artemburenok_sp_500_stock_prices.mco

307.63 kB
7,081 rows
7 columns

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

Mdlz

@kaggle.artemburenok_sp_500_stock_prices.mdlz

218.67 kB
5,411 rows
7 columns

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

Mdt

@kaggle.artemburenok_sp_500_stock_prices.mdt

457.47 kB
12,516 rows
7 columns

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

Met

@kaggle.artemburenok_sp_500_stock_prices.met

257.95 kB
5,710 rows
7 columns

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

Mgm

@kaggle.artemburenok_sp_500_stock_prices.mgm

311.75 kB
8,725 rows
7 columns

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

S&P 500 Stock Prices

About this Dataset