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

Cmg

@kaggle.artemburenok_sp_500_stock_prices.cmg

217.09 kB
4,251 rows
7 columns

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

Cmi

@kaggle.artemburenok_sp_500_stock_prices.cmi

448.94 kB
12,565 rows
7 columns

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

Cms

@kaggle.artemburenok_sp_500_stock_prices.cms

389.51 kB
12,565 rows
7 columns

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

Cnc

@kaggle.artemburenok_sp_500_stock_prices.cnc

247.38 kB
5,287 rows
7 columns

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

Cnp

@kaggle.artemburenok_sp_500_stock_prices.cnp

463.94 kB
15,344 rows
7 columns

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

Cof

@kaggle.artemburenok_sp_500_stock_prices.cof

314.84 kB
7,069 rows
7 columns

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

Coo

@kaggle.artemburenok_sp_500_stock_prices.coo

378.26 kB
10,058 rows
7 columns

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

Cop

@kaggle.artemburenok_sp_500_stock_prices.cop

415.94 kB
10,326 rows
7 columns

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

Cost

@kaggle.artemburenok_sp_500_stock_prices.cost

371.58 kB
9,184 rows
7 columns

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

Cpb

@kaggle.artemburenok_sp_500_stock_prices.cpb

398.1 kB
12,565 rows
7 columns

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

Cprt

@kaggle.artemburenok_sp_500_stock_prices.cprt

298.53 kB
7,238 rows
7 columns

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

Cpt

@kaggle.artemburenok_sp_500_stock_prices.cpt

297.46 kB
7,404 rows
7 columns

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

Crl

@kaggle.artemburenok_sp_500_stock_prices.crl

247.93 kB
5,655 rows
7 columns

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

Crm

@kaggle.artemburenok_sp_500_stock_prices.crm

237.15 kB
4,653 rows
7 columns

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

Csco

@kaggle.artemburenok_sp_500_stock_prices.csco

337.48 kB
8,270 rows
7 columns

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

Csgp

@kaggle.artemburenok_sp_500_stock_prices.csgp

276.2 kB
6,155 rows
7 columns

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

Csx

@kaggle.artemburenok_sp_500_stock_prices.csx

422.3 kB
10,618 rows
7 columns

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

Ctas

@kaggle.artemburenok_sp_500_stock_prices.ctas

368.84 kB
9,912 rows
7 columns

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

Ctlt

@kaggle.artemburenok_sp_500_stock_prices.ctlt

102.44 kB
2,109 rows
7 columns

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

Ctra

@kaggle.artemburenok_sp_500_stock_prices.ctra

316.31 kB
8,276 rows
7 columns

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

Ctsh

@kaggle.artemburenok_sp_500_stock_prices.ctsh

294.02 kB
6,163 rows
7 columns

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

Ctva

@kaggle.artemburenok_sp_500_stock_prices.ctva

47.67 kB
897 rows
7 columns

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

Cvs

@kaggle.artemburenok_sp_500_stock_prices.cvs

445.19 kB
12,565 rows
7 columns

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

Cvx

@kaggle.artemburenok_sp_500_stock_prices.cvx

531.05 kB
15,344 rows
7 columns

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

Czr

@kaggle.artemburenok_sp_500_stock_prices.czr

98.19 kB
2,073 rows
7 columns

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

D

@kaggle.artemburenok_sp_500_stock_prices.d

382.52 kB
10,779 rows
7 columns

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

Dal

@kaggle.artemburenok_sp_500_stock_prices.dal

175.45 kB
3,933 rows
7 columns

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

Dd

@kaggle.artemburenok_sp_500_stock_prices.dd

481.22 kB
12,745 rows
7 columns

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

De

@kaggle.artemburenok_sp_500_stock_prices.de

473.38 kB
12,745 rows
7 columns

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

Dfs

@kaggle.artemburenok_sp_500_stock_prices.dfs

187.56 kB
3,904 rows
7 columns

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

Dg

@kaggle.artemburenok_sp_500_stock_prices.dg

164.39 kB
3,293 rows
7 columns

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

Dgx

@kaggle.artemburenok_sp_500_stock_prices.dgx

284.4 kB
6,542 rows
7 columns

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

Dhi

@kaggle.artemburenok_sp_500_stock_prices.dhi

313.84 kB
7,689 rows
7 columns

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

Dhr

@kaggle.artemburenok_sp_500_stock_prices.dhr

421.97 kB
11,085 rows
7 columns

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

Dis

@kaggle.artemburenok_sp_500_stock_prices.dis

577.77 kB
15,344 rows
7 columns

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

Dish

@kaggle.artemburenok_sp_500_stock_prices.dish

276.08 kB
6,920 rows
7 columns

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

Dlr

@kaggle.artemburenok_sp_500_stock_prices.dlr

220.63 kB
4,563 rows
7 columns

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

Dltr

@kaggle.artemburenok_sp_500_stock_prices.dltr

309.78 kB
6,994 rows
7 columns

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

Dov

@kaggle.artemburenok_sp_500_stock_prices.dov

418.89 kB
10,779 rows
7 columns

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

Dow

@kaggle.artemburenok_sp_500_stock_prices.dow

49.88 kB
943 rows
7 columns

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

Dpz

@kaggle.artemburenok_sp_500_stock_prices.dpz

220.88 kB
4,640 rows
7 columns

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

Dri

@kaggle.artemburenok_sp_500_stock_prices.dri

304.29 kB
6,950 rows
7 columns

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

Dte

@kaggle.artemburenok_sp_500_stock_prices.dte

473.51 kB
15,344 rows
7 columns

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

Duk

@kaggle.artemburenok_sp_500_stock_prices.duk

398.99 kB
10,779 rows
7 columns

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

Dva

@kaggle.artemburenok_sp_500_stock_prices.dva

296.39 kB
6,828 rows
7 columns

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

Dvn

@kaggle.artemburenok_sp_500_stock_prices.dvn

350.93 kB
9,427 rows
7 columns

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

Dxc

@kaggle.artemburenok_sp_500_stock_prices.dxc

399.12 kB
10,326 rows
7 columns

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

Dxcm

@kaggle.artemburenok_sp_500_stock_prices.dxcm

201.82 kB
4,449 rows
7 columns

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

Ea

@kaggle.artemburenok_sp_500_stock_prices.ea

345.58 kB
8,374 rows
7 columns

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

Ebay

@kaggle.artemburenok_sp_500_stock_prices.ebay

291.99 kB
6,096 rows
7 columns

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