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

314.73 KB
7734 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

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

204.49 KB
4558 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

310.75 KB
7257 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

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

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

324.58 KB
9330 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

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

221.34 KB
4898 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

324.99 KB
8792 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

141.03 KB
2888 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

201.26 KB
4548 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

54.17 KB
1012 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

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

314.33 KB
7508 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

176.95 KB
3796 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

383.5 KB
9265 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

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

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

327.74 KB
7532 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

277.1 KB
6311 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

347.54 KB
9714 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

112.77 KB
2494 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

224.76 KB
5151 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

361.87 KB
10778 rows
7 columns


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