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

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

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

192.56 KB
4244 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

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

363.02 KB
10448 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

186.95 KB
3811 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

388.44 KB
9618 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

431.97 KB
10831 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

253.23 KB
5811 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

270.53 KB
6288 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

378.92 KB
12515 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

185.39 KB
3712 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

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

57.82 KB
1247 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

391.74 KB
10325 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

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

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

156.04 KB
3320 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

282.16 KB
6260 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

314.45 KB
7909 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

278.94 KB
6447 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

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

384.56 KB
9847 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

283.64 KB
6923 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

297.68 KB
6815 rows
7 columns


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