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

460.61 KB
12745 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

449.09 KB
11588 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

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

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

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

366.05 KB
9733 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

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

394.08 KB
10831 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

205.49 KB
4531 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

76.33 KB
1533 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

151.74 KB
3181 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

181.69 KB
4274 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

211.49 KB
4168 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

284.48 KB
7271 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

293.76 KB
6225 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

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

518.83 KB
14209 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

317.59 KB
7490 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

312.24 KB
7073 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

300.42 KB
7081 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

213.54 KB
5411 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

446.74 KB
12516 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

251.91 KB
5710 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

304.45 KB
8725 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