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

212 KB
4251 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

438.41 KB
12565 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

380.38 KB
12565 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

241.58 KB
5287 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

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

307.46 KB
7069 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

369.4 KB
10058 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

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

362.87 KB
9184 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

388.77 KB
12565 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

291.53 KB
7238 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

290.49 KB
7404 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

242.12 KB
5655 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

231.59 KB
4653 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

329.57 KB
8270 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

269.73 KB
6155 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

412.4 KB
10618 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

360.19 KB
9912 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

100.04 KB
2109 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

308.9 KB
8276 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

287.13 KB
6163 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

46.56 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

434.75 KB
12565 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

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

95.89 KB
2073 rows
7 columns


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