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

Awk

@kaggle.artemburenok_sp_500_stock_prices.awk

171.63 KB
3688 rows
7 columns


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

Axp

@kaggle.artemburenok_sp_500_stock_prices.axp

490.68 KB
12745 rows
7 columns


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

Azo

@kaggle.artemburenok_sp_500_stock_prices.azo

329.52 KB
7988 rows
7 columns


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

Ba

@kaggle.artemburenok_sp_500_stock_prices.ba

563.66 KB
15344 rows
7 columns


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

Bac

@kaggle.artemburenok_sp_500_stock_prices.bac

414.82 KB
12565 rows
7 columns


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

Ball

@kaggle.artemburenok_sp_500_stock_prices.ball

419.77 KB
12565 rows
7 columns


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

Bax

@kaggle.artemburenok_sp_500_stock_prices.bax

404.82 KB
10371 rows
7 columns


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

Bbwi

@kaggle.artemburenok_sp_500_stock_prices.bbwi

393.19 KB
10263 rows
7 columns


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

Bby

@kaggle.artemburenok_sp_500_stock_prices.bby

377.84 KB
9492 rows
7 columns


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

Bdx

@kaggle.artemburenok_sp_500_stock_prices.bdx

445.36 KB
12565 rows
7 columns


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

Ben

@kaggle.artemburenok_sp_500_stock_prices.ben

385.87 KB
9888 rows
7 columns


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

Biib

@kaggle.artemburenok_sp_500_stock_prices.biib

328.62 KB
7871 rows
7 columns


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

Bio

@kaggle.artemburenok_sp_500_stock_prices.bio

358.69 KB
10792 rows
7 columns


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

Bk

@kaggle.artemburenok_sp_500_stock_prices.bk

431.92 KB
12515 rows
7 columns


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

Bkng

@kaggle.artemburenok_sp_500_stock_prices.bkng

282.5 KB
5967 rows
7 columns


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

Bkr

@kaggle.artemburenok_sp_500_stock_prices.bkr

336.06 KB
8996 rows
7 columns


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

Blk

@kaggle.artemburenok_sp_500_stock_prices.blk

276.5 KB
5839 rows
7 columns


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

Bmy

@kaggle.artemburenok_sp_500_stock_prices.bmy

464.4 KB
12745 rows
7 columns


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

Br

@kaggle.artemburenok_sp_500_stock_prices.br

177.51 KB
3962 rows
7 columns


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

Bro

@kaggle.artemburenok_sp_500_stock_prices.bro

328.65 KB
10550 rows
7 columns


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

Bsx

@kaggle.artemburenok_sp_500_stock_prices.bsx

271.35 KB
7701 rows
7 columns


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

Bwa

@kaggle.artemburenok_sp_500_stock_prices.bwa

304.83 KB
7388 rows
7 columns


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

Bxp

@kaggle.artemburenok_sp_500_stock_prices.bxp

275.66 KB
6416 rows
7 columns


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

C

@kaggle.artemburenok_sp_500_stock_prices.c

420.88 KB
11588 rows
7 columns


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

Cag

@kaggle.artemburenok_sp_500_stock_prices.cag

368.44 KB
10779 rows
7 columns


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