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

Nee

@kaggle.artemburenok_sp_500_stock_prices.nee

440.78 kB
12,565 rows
7 columns

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

Nem

@kaggle.artemburenok_sp_500_stock_prices.nem

387.95 kB
10,779 rows
7 columns

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

Nflx

@kaggle.artemburenok_sp_500_stock_prices.nflx

267.78 kB
5,177 rows
7 columns

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

Ni

@kaggle.artemburenok_sp_500_stock_prices.ni

381.79 kB
12,565 rows
7 columns

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

Nke

@kaggle.artemburenok_sp_500_stock_prices.nke

434.31 kB
10,599 rows
7 columns

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

Noc

@kaggle.artemburenok_sp_500_stock_prices.noc

424.79 kB
10,326 rows
7 columns

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

Now

@kaggle.artemburenok_sp_500_stock_prices.now

136.34 kB
2,632 rows
7 columns

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

Nrg

@kaggle.artemburenok_sp_500_stock_prices.nrg

202.8 kB
4,792 rows
7 columns

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

Nsc

@kaggle.artemburenok_sp_500_stock_prices.nsc

406.47 kB
10,221 rows
7 columns

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

Ntap

@kaggle.artemburenok_sp_500_stock_prices.ntap

292.76 kB
6,813 rows
7 columns

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

Ntrs

@kaggle.artemburenok_sp_500_stock_prices.ntrs

388.64 kB
10,779 rows
7 columns

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

Nue

@kaggle.artemburenok_sp_500_stock_prices.nue

404.32 kB
10,779 rows
7 columns

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

Nvda

@kaggle.artemburenok_sp_500_stock_prices.nvda

285.74 kB
6,014 rows
7 columns

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

Nvr

@kaggle.artemburenok_sp_500_stock_prices.nvr

334.58 kB
9,427 rows
7 columns

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

Nwl

@kaggle.artemburenok_sp_500_stock_prices.nwl

356.2 kB
10,779 rows
7 columns

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

Nws

@kaggle.artemburenok_sp_500_stock_prices.nws

87.48 kB
2,390 rows
7 columns

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

Nwsa

@kaggle.artemburenok_sp_500_stock_prices.nwsa

91.04 kB
2,390 rows
7 columns

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

Nxpi

@kaggle.artemburenok_sp_500_stock_prices.nxpi

156.03 kB
3,111 rows
7 columns

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

O

@kaggle.artemburenok_sp_500_stock_prices.o

285.18 kB
7,090 rows
7 columns

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

Odfl

@kaggle.artemburenok_sp_500_stock_prices.odfl

314.21 kB
7,844 rows
7 columns

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

Ogn

@kaggle.artemburenok_sp_500_stock_prices.ogn

23.83 kB
400 rows
7 columns

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

Oke

@kaggle.artemburenok_sp_500_stock_prices.oke

386.08 kB
10,641 rows
7 columns

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

Omc

@kaggle.artemburenok_sp_500_stock_prices.omc

380.43 kB
10,779 rows
7 columns

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

On

@kaggle.artemburenok_sp_500_stock_prices.on

205.09 kB
5,692 rows
7 columns

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

Orcl

@kaggle.artemburenok_sp_500_stock_prices.orcl

377.54 kB
9,266 rows
7 columns

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