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

D

@kaggle.artemburenok_sp_500_stock_prices.d

373.56 KB
10779 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

171.34 KB
3933 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

469.94 KB
12745 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

462.28 KB
12745 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

183.16 KB
3904 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

160.54 KB
3293 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

277.74 KB
6542 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

306.48 KB
7689 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

412.08 KB
11085 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

564.23 KB
15344 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

269.61 KB
6920 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

215.46 KB
4563 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

302.52 KB
6994 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

409.07 KB
10779 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

48.71 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

215.7 KB
4640 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

297.16 KB
6950 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

462.41 KB
15344 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

389.64 KB
10779 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

289.44 KB
6828 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

342.7 KB
9427 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

389.76 KB
10326 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

197.09 KB
4449 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

337.48 KB
8374 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

285.15 KB
6096 rows
7 columns


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