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
);