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

Rtx

@kaggle.artemburenok_sp_500_stock_prices.rtx

552.8 KB
15281 rows
7 columns


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

Sbac

@kaggle.artemburenok_sp_500_stock_prices.sbac

268.16 KB
5914 rows
7 columns


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

Sbny

@kaggle.artemburenok_sp_500_stock_prices.sbny

211.06 KB
4716 rows
7 columns


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

Sbux

@kaggle.artemburenok_sp_500_stock_prices.sbux

327.56 KB
7674 rows
7 columns


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

Schw

@kaggle.artemburenok_sp_500_stock_prices.schw

347.28 KB
8879 rows
7 columns


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

Sedg

@kaggle.artemburenok_sp_500_stock_prices.sedg

94.02 KB
1945 rows
7 columns


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

See

@kaggle.artemburenok_sp_500_stock_prices.see

362.54 KB
10779 rows
7 columns


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

Shw

@kaggle.artemburenok_sp_500_stock_prices.shw

401.66 KB
10779 rows
7 columns


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

Sivb

@kaggle.artemburenok_sp_500_stock_prices.sivb

330.11 KB
8855 rows
7 columns


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

Sjm

@kaggle.artemburenok_sp_500_stock_prices.sjm

278.05 KB
7081 rows
7 columns


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

Slb

@kaggle.artemburenok_sp_500_stock_prices.slb

400.16 KB
10326 rows
7 columns


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

Sna

@kaggle.artemburenok_sp_500_stock_prices.sna

407.8 KB
12565 rows
7 columns


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

Snps

@kaggle.artemburenok_sp_500_stock_prices.snps

295.22 KB
7759 rows
7 columns


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

So

@kaggle.artemburenok_sp_500_stock_prices.so

349.35 KB
10326 rows
7 columns


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

Spg

@kaggle.artemburenok_sp_500_stock_prices.spg

321.72 KB
7303 rows
7 columns


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

Spgi

@kaggle.artemburenok_sp_500_stock_prices.spgi

437.57 KB
12565 rows
7 columns


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

Sre

@kaggle.artemburenok_sp_500_stock_prices.sre

271.49 KB
6157 rows
7 columns


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

Ste

@kaggle.artemburenok_sp_500_stock_prices.ste

286.19 KB
7693 rows
7 columns


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

Stt

@kaggle.artemburenok_sp_500_stock_prices.stt

391.52 KB
10779 rows
7 columns


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

Stx

@kaggle.artemburenok_sp_500_stock_prices.stx

223.47 KB
5037 rows
7 columns


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

Stz

@kaggle.artemburenok_sp_500_stock_prices.stz

305.62 KB
7745 rows
7 columns


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

Swk

@kaggle.artemburenok_sp_500_stock_prices.swk

385.83 KB
10779 rows
7 columns


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

Swks

@kaggle.artemburenok_sp_500_stock_prices.swks

331.79 KB
9646 rows
7 columns


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

Syf

@kaggle.artemburenok_sp_500_stock_prices.syf

94.27 KB
2109 rows
7 columns


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

Syk

@kaggle.artemburenok_sp_500_stock_prices.syk

394.49 KB
10779 rows
7 columns


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