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

Alk

@kaggle.artemburenok_sp_500_stock_prices.alk

368.72 KB
10779 rows
7 columns


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

All

@kaggle.artemburenok_sp_500_stock_prices.all

306.44 KB
7438 rows
7 columns


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

Alle

@kaggle.artemburenok_sp_500_stock_prices.alle

110.99 KB
2284 rows
7 columns


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

Amat

@kaggle.artemburenok_sp_500_stock_prices.amat

381.91 KB
10779 rows
7 columns


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

Amcr

@kaggle.artemburenok_sp_500_stock_prices.amcr

61.16 KB
2664 rows
7 columns


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

Amd

@kaggle.artemburenok_sp_500_stock_prices.amd

341.06 KB
10779 rows
7 columns


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

Ame

@kaggle.artemburenok_sp_500_stock_prices.ame

357.01 KB
9681 rows
7 columns


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

Amgn

@kaggle.artemburenok_sp_500_stock_prices.amgn

389.13 KB
9956 rows
7 columns


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

Amp

@kaggle.artemburenok_sp_500_stock_prices.amp

209.94 KB
4342 rows
7 columns


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

Amt

@kaggle.artemburenok_sp_500_stock_prices.amt

281.11 KB
6241 rows
7 columns


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

Amzn

@kaggle.artemburenok_sp_500_stock_prices.amzn

323.44 KB
6439 rows
7 columns


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

Anet

@kaggle.artemburenok_sp_500_stock_prices.anet

107.91 KB
2147 rows
7 columns


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

Anss

@kaggle.artemburenok_sp_500_stock_prices.anss

283 KB
6667 rows
7 columns


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

Aon

@kaggle.artemburenok_sp_500_stock_prices.aon

398.24 KB
10726 rows
7 columns


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

Aos

@kaggle.artemburenok_sp_500_stock_prices.aos

357.58 KB
9883 rows
7 columns


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

Apa

@kaggle.artemburenok_sp_500_stock_prices.apa

414.22 KB
10991 rows
7 columns


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

Apd

@kaggle.artemburenok_sp_500_stock_prices.apd

417.48 KB
10779 rows
7 columns


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

Aph

@kaggle.artemburenok_sp_500_stock_prices.aph

328.2 KB
7833 rows
7 columns


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

Aptv

@kaggle.artemburenok_sp_500_stock_prices.aptv

139.76 KB
2786 rows
7 columns


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

Are

@kaggle.artemburenok_sp_500_stock_prices.are

275.4 KB
6431 rows
7 columns


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

Ato

@kaggle.artemburenok_sp_500_stock_prices.ato

316.51 KB
9822 rows
7 columns


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

Atvi

@kaggle.artemburenok_sp_500_stock_prices.atvi

290.27 KB
7338 rows
7 columns


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

Avb

@kaggle.artemburenok_sp_500_stock_prices.avb

304.1 KB
7242 rows
7 columns


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

Avgo

@kaggle.artemburenok_sp_500_stock_prices.avgo

166.46 KB
3363 rows
7 columns


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

Avy

@kaggle.artemburenok_sp_500_stock_prices.avy

409.12 KB
12565 rows
7 columns


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