S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Table List

500 tables(151.9 MB)

results for

Ftv

Qcom

Incy

Ceg

Invh

@kaggle.artemburenok_sp_500_stock_prices.invh

67.18 KB
1478 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Feb 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.100000381469727	20.420000076293945	19.799999237060547	20	17.851713180541992	30833000
Thu Feb 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.040000915527344	20.40999984741211	20.040000915527344	20.229999542236328	18.057003021240234	4901200
Fri Feb 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.350000381469727	20.799999237060547	20.299999237060547	20.6299991607666	18.414037704467773	2631500
Mon Feb 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	21.13999938964844	21.13999938964844	20.549999237060547	20.729999542236328	18.503297805786133	1836800
Tue Feb 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.75	20.86000061035156	20.6200008392334	20.799999237060547	18.56577491760254	3521100
Wed Feb 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.799999237060547	20.920000076293945	20.729999542236328	20.84000015258789	18.60148048400879	973600
Thu Feb 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.88999938964844	20.96999931335449	20.82999992370605	20.8799991607666	18.637184143066406	1798600
Fri Feb 10 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.920000076293945	21.8700008392334	20.780000686645508	21.020000457763672	18.762147903442383	1560800
Mon Feb 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	21.13999938964844	21.190000534057617	20.95499992370605	21	18.744295120239254	896000
Tue Feb 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.88999938964844	21.049999237060547	20.75	21.030000686645508	18.771072387695312	1143100


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