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

A

@kaggle.artemburenok_sp_500_stock_prices.a

265.58 KB
5805 rows
7 columns


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

Aal

@kaggle.artemburenok_sp_500_stock_prices.aal

189.52 KB
4334 rows
7 columns


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

Aap

@kaggle.artemburenok_sp_500_stock_prices.aap

252.94 KB
5297 rows
7 columns


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

Aapl

@kaggle.artemburenok_sp_500_stock_prices.aapl

437.76 KB
10591 rows
7 columns


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

Abbv

@kaggle.artemburenok_sp_500_stock_prices.abbv

124.38 KB
2506 rows
7 columns


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

Abc

@kaggle.artemburenok_sp_500_stock_prices.abc

301.45 KB
6974 rows
7 columns


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

Abmd

@kaggle.artemburenok_sp_500_stock_prices.abmd

289.31 KB
8917 rows
7 columns


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

Abt

@kaggle.artemburenok_sp_500_stock_prices.abt

427.11 KB
10779 rows
7 columns


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

Acgl

@kaggle.artemburenok_sp_500_stock_prices.acgl

280.08 KB
6861 rows
7 columns


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

Acn

@kaggle.artemburenok_sp_500_stock_prices.acn

250.99 KB
5386 rows
7 columns


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

Adbe

@kaggle.artemburenok_sp_500_stock_prices.adbe

374.18 KB
9159 rows
7 columns


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

Adi

@kaggle.artemburenok_sp_500_stock_prices.adi

390.18 KB
10779 rows
7 columns


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

Adm

@kaggle.artemburenok_sp_500_stock_prices.adm

402.18 KB
10779 rows
7 columns


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

Adp

@kaggle.artemburenok_sp_500_stock_prices.adp

428 KB
10779 rows
7 columns


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

Adsk

@kaggle.artemburenok_sp_500_stock_prices.adsk

364.78 KB
9442 rows
7 columns


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

Aee

@kaggle.artemburenok_sp_500_stock_prices.aee

252.5 KB
6279 rows
7 columns


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

Aep

@kaggle.artemburenok_sp_500_stock_prices.aep

457.7 KB
15344 rows
7 columns


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

Aes

@kaggle.artemburenok_sp_500_stock_prices.aes

270.21 KB
7928 rows
7 columns


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

Afl

@kaggle.artemburenok_sp_500_stock_prices.afl

395.93 KB
10779 rows
7 columns


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

Aig

@kaggle.artemburenok_sp_500_stock_prices.aig

474.55 KB
12599 rows
7 columns


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

Aiz

@kaggle.artemburenok_sp_500_stock_prices.aiz

216.83 KB
4748 rows
7 columns


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

Ajg

@kaggle.artemburenok_sp_500_stock_prices.ajg

324.49 KB
9701 rows
7 columns


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

Akam

@kaggle.artemburenok_sp_500_stock_prices.akam

259.17 KB
5819 rows
7 columns


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

Alb

@kaggle.artemburenok_sp_500_stock_prices.alb

296.71 KB
7255 rows
7 columns


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

Algn

@kaggle.artemburenok_sp_500_stock_prices.algn

239.75 KB
5504 rows
7 columns


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