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

F

@kaggle.artemburenok_sp_500_stock_prices.f

428.35 KB
12745 rows
7 columns


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

Fang

@kaggle.artemburenok_sp_500_stock_prices.fang

127.69 KB
2559 rows
7 columns


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

Fast

@kaggle.artemburenok_sp_500_stock_prices.fast

346.49 KB
8901 rows
7 columns


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

Fbhs

@kaggle.artemburenok_sp_500_stock_prices.fbhs

134.1 KB
2830 rows
7 columns


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

Fcx

@kaggle.artemburenok_sp_500_stock_prices.fcx

282.07 KB
6908 rows
7 columns


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

Fds

@kaggle.artemburenok_sp_500_stock_prices.fds

298.96 KB
6661 rows
7 columns


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

Fdx

@kaggle.artemburenok_sp_500_stock_prices.fdx

420.5 KB
11267 rows
7 columns


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

Fe

@kaggle.artemburenok_sp_500_stock_prices.fe

238.57 KB
6315 rows
7 columns


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

Ffiv

@kaggle.artemburenok_sp_500_stock_prices.ffiv

277.01 KB
5922 rows
7 columns


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

Fis

@kaggle.artemburenok_sp_500_stock_prices.fis

242.13 KB
5406 rows
7 columns


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

Fisv

@kaggle.artemburenok_sp_500_stock_prices.fisv

355.15 KB
9129 rows
7 columns


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

Fitb

@kaggle.artemburenok_sp_500_stock_prices.fitb

385.06 KB
10779 rows
7 columns


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

Flt

@kaggle.artemburenok_sp_500_stock_prices.flt

148.5 KB
3020 rows
7 columns


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

Fmc

@kaggle.artemburenok_sp_500_stock_prices.fmc

398.17 KB
10779 rows
7 columns


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

Fox

@kaggle.artemburenok_sp_500_stock_prices.fox

45.98 KB
948 rows
7 columns


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

Foxa

@kaggle.artemburenok_sp_500_stock_prices.foxa

46.78 KB
949 rows
7 columns


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

Frc

@kaggle.artemburenok_sp_500_stock_prices.frc

145.92 KB
3024 rows
7 columns


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

Frt

@kaggle.artemburenok_sp_500_stock_prices.frt

394.02 KB
12515 rows
7 columns


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

Ftnt

@kaggle.artemburenok_sp_500_stock_prices.ftnt

157.19 KB
3290 rows
7 columns


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

Ftv

@kaggle.artemburenok_sp_500_stock_prices.ftv

81.85 KB
1624 rows
7 columns


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

Gd

@kaggle.artemburenok_sp_500_stock_prices.gd

515.78 KB
15344 rows
7 columns


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

Ge

@kaggle.artemburenok_sp_500_stock_prices.ge

533.58 KB
15344 rows
7 columns


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

Gen

@kaggle.artemburenok_sp_500_stock_prices.gen

285.04 KB
8435 rows
7 columns


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

Gild

@kaggle.artemburenok_sp_500_stock_prices.gild

326.09 KB
7783 rows
7 columns


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

Gis

@kaggle.artemburenok_sp_500_stock_prices.gis

399.78 KB
10779 rows
7 columns


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