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

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

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

261.5 KB
5177 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

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

424.13 KB
10599 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

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

133.14 KB
2632 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

198.05 KB
4792 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

396.94 KB
10221 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

285.9 KB
6813 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

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

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

279.04 KB
6014 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

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

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

85.43 KB
2390 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

88.9 KB
2390 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

152.38 KB
3111 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

278.5 KB
7090 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

306.85 KB
7844 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.27 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

377.03 KB
10641 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

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

200.28 KB
5692 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

368.69 KB
9266 rows
7 columns


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