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

Txt

@kaggle.artemburenok_sp_500_stock_prices.txt

425.95 kB
12,565 rows
7 columns

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

Tyl

@kaggle.artemburenok_sp_500_stock_prices.tyl

344.32 kB
10,779 rows
7 columns

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

Ual

@kaggle.artemburenok_sp_500_stock_prices.ual

197.18 kB
4,244 rows
7 columns

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

Udr

@kaggle.artemburenok_sp_500_stock_prices.udr

325.91 kB
10,779 rows
7 columns

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

Uhs

@kaggle.artemburenok_sp_500_stock_prices.uhs

371.73 kB
10,448 rows
7 columns

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

Ulta

@kaggle.artemburenok_sp_500_stock_prices.ulta

191.44 kB
3,811 rows
7 columns

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

Unh

@kaggle.artemburenok_sp_500_stock_prices.unh

397.76 kB
9,618 rows
7 columns

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

Unp

@kaggle.artemburenok_sp_500_stock_prices.unp

442.34 kB
10,831 rows
7 columns

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

Ups

@kaggle.artemburenok_sp_500_stock_prices.ups

259.31 kB
5,811 rows
7 columns

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

Uri

@kaggle.artemburenok_sp_500_stock_prices.uri

277.03 kB
6,288 rows
7 columns

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

Usb

@kaggle.artemburenok_sp_500_stock_prices.usb

388.01 kB
12,515 rows
7 columns

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

V

@kaggle.artemburenok_sp_500_stock_prices.v

189.84 kB
3,712 rows
7 columns

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

Vfc

@kaggle.artemburenok_sp_500_stock_prices.vfc

422.63 kB
10,779 rows
7 columns

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

Vici

@kaggle.artemburenok_sp_500_stock_prices.vici

59.21 kB
1,247 rows
7 columns

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

Vlo

@kaggle.artemburenok_sp_500_stock_prices.vlo

401.14 kB
10,325 rows
7 columns

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

Vmc

@kaggle.artemburenok_sp_500_stock_prices.vmc

431.06 kB
12,565 rows
7 columns

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

Vno

@kaggle.artemburenok_sp_500_stock_prices.vno

410 kB
10,779 rows
7 columns

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

Vrsk

@kaggle.artemburenok_sp_500_stock_prices.vrsk

159.78 kB
3,320 rows
7 columns

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

Vrsn

@kaggle.artemburenok_sp_500_stock_prices.vrsn

288.93 kB
6,260 rows
7 columns

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

Vrtx

@kaggle.artemburenok_sp_500_stock_prices.vrtx

322 kB
7,909 rows
7 columns

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

Vtr

@kaggle.artemburenok_sp_500_stock_prices.vtr

285.64 kB
6,447 rows
7 columns

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

Vtrs

@kaggle.artemburenok_sp_500_stock_prices.vtrs

368.68 kB
10,779 rows
7 columns

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

Vz

@kaggle.artemburenok_sp_500_stock_prices.vz

393.79 kB
9,847 rows
7 columns

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

Wab

@kaggle.artemburenok_sp_500_stock_prices.wab

290.45 kB
6,923 rows
7 columns

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

Wat

@kaggle.artemburenok_sp_500_stock_prices.wat

304.83 kB
6,815 rows
7 columns

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

Wba

@kaggle.artemburenok_sp_500_stock_prices.wba

392.39 kB
10,779 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

197.05 kB
4,390 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

383.39 kB
11,126 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

382.57 kB
10,779 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

347.38 kB
10,777 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

432.42 kB
12,745 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

441.49 kB
12,565 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

317.13 kB
8,689 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

401.77 kB
10,326 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

470.94 kB
12,685 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

427.67 kB
12,395 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

94.13 kB
1,883 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

368.8 kB
10,779 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

237 kB
5,412 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

420.86 kB
12,515 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

250.99 kB
5,069 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

386.15 kB
12,565 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

529.11 kB
15,344 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

326.77 kB
8,907 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

135.35 kB
2,811 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

302.25 kB
6,353 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

258.43 kB
5,382 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

325.29 kB
7,893 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

375.07 kB
10,779 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

125.22 kB
2,485 rows
7 columns

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