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

271.96 kB
5,805 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

194.06 kB
4,334 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

259.01 kB
5,297 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

448.27 kB
10,591 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

127.37 kB
2,506 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

308.68 kB
6,974 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

296.25 kB
8,917 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

437.36 kB
10,779 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

286.8 kB
6,861 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

257.01 kB
5,386 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

383.16 kB
9,159 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

399.54 kB
10,779 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

411.83 kB
10,779 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

438.27 kB
10,779 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

373.53 kB
9,442 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

258.56 kB
6,279 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

468.68 kB
15,344 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

276.69 kB
7,928 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

405.44 kB
10,779 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

485.94 kB
12,599 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

222.03 kB
4,748 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

332.27 kB
9,701 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

265.39 kB
5,819 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

303.84 kB
7,255 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

245.5 kB
5,504 rows
7 columns

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

Alk

@kaggle.artemburenok_sp_500_stock_prices.alk

377.57 kB
10,779 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

313.79 kB
7,438 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

113.66 kB
2,284 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

391.07 kB
10,779 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

62.63 kB
2,664 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

349.24 kB
10,779 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

365.58 kB
9,681 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

398.47 kB
9,956 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

214.97 kB
4,342 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

287.86 kB
6,241 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

331.2 kB
6,439 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

110.5 kB
2,147 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

289.79 kB
6,667 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

407.8 kB
10,726 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

366.17 kB
9,883 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

424.16 kB
10,991 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

427.5 kB
10,779 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

336.07 kB
7,833 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

143.12 kB
2,786 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

282.01 kB
6,431 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

324.11 kB
9,822 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

297.24 kB
7,338 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

311.4 kB
7,242 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

170.45 kB
3,363 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

418.94 kB
12,565 rows
7 columns

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