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

Mhk

@kaggle.artemburenok_sp_500_stock_prices.mhk

322.28 kB
7,734 rows
7 columns

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

Mkc

@kaggle.artemburenok_sp_500_stock_prices.mkc

408.74 kB
12,565 rows
7 columns

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

Mktx

@kaggle.artemburenok_sp_500_stock_prices.mktx

209.4 kB
4,558 rows
7 columns

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

Mlm

@kaggle.artemburenok_sp_500_stock_prices.mlm

318.2 kB
7,257 rows
7 columns

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

Mmc

@kaggle.artemburenok_sp_500_stock_prices.mmc

434.65 kB
12,565 rows
7 columns

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

Mmm

@kaggle.artemburenok_sp_500_stock_prices.mmm

542.41 kB
15,344 rows
7 columns

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

Mnst

@kaggle.artemburenok_sp_500_stock_prices.mnst

332.37 kB
9,330 rows
7 columns

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

Mo

@kaggle.artemburenok_sp_500_stock_prices.mo

551.47 kB
15,344 rows
7 columns

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

Moh

@kaggle.artemburenok_sp_500_stock_prices.moh

226.65 kB
4,898 rows
7 columns

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

Mos

@kaggle.artemburenok_sp_500_stock_prices.mos

332.79 kB
8,792 rows
7 columns

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

Mpc

@kaggle.artemburenok_sp_500_stock_prices.mpc

144.42 kB
2,888 rows
7 columns

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

Mpwr

@kaggle.artemburenok_sp_500_stock_prices.mpwr

206.09 kB
4,548 rows
7 columns

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

Mrna

@kaggle.artemburenok_sp_500_stock_prices.mrna

55.47 kB
1,012 rows
7 columns

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

Mro

@kaggle.artemburenok_sp_500_stock_prices.mro

525.6 kB
15,344 rows
7 columns

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

Ms

@kaggle.artemburenok_sp_500_stock_prices.ms

321.87 kB
7,508 rows
7 columns

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

Msci

@kaggle.artemburenok_sp_500_stock_prices.msci

181.2 kB
3,796 rows
7 columns

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

Msft

@kaggle.artemburenok_sp_500_stock_prices.msft

392.7 kB
9,265 rows
7 columns

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

Msi

@kaggle.artemburenok_sp_500_stock_prices.msi

573.33 kB
15,344 rows
7 columns

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

Mtb

@kaggle.artemburenok_sp_500_stock_prices.mtb

399.39 kB
10,779 rows
7 columns

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

Mtch

@kaggle.artemburenok_sp_500_stock_prices.mtch

335.61 kB
7,532 rows
7 columns

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

Mtd

@kaggle.artemburenok_sp_500_stock_prices.mtd

283.75 kB
6,311 rows
7 columns

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

Mu

@kaggle.artemburenok_sp_500_stock_prices.mu

355.88 kB
9,714 rows
7 columns

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

Nclh

@kaggle.artemburenok_sp_500_stock_prices.nclh

115.47 kB
2,494 rows
7 columns

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

Ndaq

@kaggle.artemburenok_sp_500_stock_prices.ndaq

230.16 kB
5,151 rows
7 columns

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

Ndsn

@kaggle.artemburenok_sp_500_stock_prices.ndsn

370.55 kB
10,778 rows
7 columns

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