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

Wba

@kaggle.artemburenok_sp_500_stock_prices.wba

383.19 KB
10779 rows
7 columns


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

Wbd

@kaggle.artemburenok_sp_500_stock_prices.wbd

192.43 KB
4390 rows
7 columns


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

Wdc

@kaggle.artemburenok_sp_500_stock_prices.wdc

374.41 KB
11126 rows
7 columns


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

Wec

@kaggle.artemburenok_sp_500_stock_prices.wec

373.61 KB
10779 rows
7 columns


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

Well

@kaggle.artemburenok_sp_500_stock_prices.well

339.24 KB
10777 rows
7 columns


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

Wfc

@kaggle.artemburenok_sp_500_stock_prices.wfc

422.28 KB
12745 rows
7 columns


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

Whr

@kaggle.artemburenok_sp_500_stock_prices.whr

431.14 KB
12565 rows
7 columns


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

Wm

@kaggle.artemburenok_sp_500_stock_prices.wm

309.7 KB
8689 rows
7 columns


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

Wmb

@kaggle.artemburenok_sp_500_stock_prices.wmb

392.36 KB
10326 rows
7 columns


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

Wmt

@kaggle.artemburenok_sp_500_stock_prices.wmt

459.9 KB
12685 rows
7 columns


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

Wrb

@kaggle.artemburenok_sp_500_stock_prices.wrb

417.65 KB
12395 rows
7 columns


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

Wrk

@kaggle.artemburenok_sp_500_stock_prices.wrk

91.92 KB
1883 rows
7 columns


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

Wst

@kaggle.artemburenok_sp_500_stock_prices.wst

360.16 KB
10779 rows
7 columns


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

Wtw

@kaggle.artemburenok_sp_500_stock_prices.wtw

231.44 KB
5412 rows
7 columns


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

Wy

@kaggle.artemburenok_sp_500_stock_prices.wy

410.99 KB
12515 rows
7 columns


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

Wynn

@kaggle.artemburenok_sp_500_stock_prices.wynn

245.11 KB
5069 rows
7 columns


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

Xel

@kaggle.artemburenok_sp_500_stock_prices.xel

377.1 KB
12565 rows
7 columns


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

Xom

@kaggle.artemburenok_sp_500_stock_prices.xom

516.71 KB
15344 rows
7 columns


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

Xray

@kaggle.artemburenok_sp_500_stock_prices.xray

319.11 KB
8907 rows
7 columns


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

Xyl

@kaggle.artemburenok_sp_500_stock_prices.xyl

132.17 KB
2811 rows
7 columns


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

Yum

@kaggle.artemburenok_sp_500_stock_prices.yum

295.17 KB
6353 rows
7 columns


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

Zbh

@kaggle.artemburenok_sp_500_stock_prices.zbh

252.37 KB
5382 rows
7 columns


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

Zbra

@kaggle.artemburenok_sp_500_stock_prices.zbra

317.67 KB
7893 rows
7 columns


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

Zion

@kaggle.artemburenok_sp_500_stock_prices.zion

366.28 KB
10779 rows
7 columns


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

Zts

@kaggle.artemburenok_sp_500_stock_prices.zts

122.29 KB
2485 rows
7 columns


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