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

Kmi

@kaggle.artemburenok_sp_500_stock_prices.kmi

123.68 KB
2980 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Feb 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.700000762939453	32.13999938964844	30.75	31.049999237060547	17.983470916748047	50610600
Mon Feb 14 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.049999237060547	31.299999237060547	30.700000762939453	30.700000762939453	17.780750274658203	6275900
Tue Feb 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.899999618530277	31.149999618530277	30.729999542236328	30.940000534057617	17.91975975036621	4337800
Wed Feb 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.049999237060547	31.440000534057617	30.65999984741211	30.71999931335449	17.792333602905273	4627100
Thu Feb 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.68000030517578	31.09000015258789	30.51000022888184	30.549999237060547	17.69388198852539	3290700
Fri Feb 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.68000030517578	31.3799991607666	30.399999618530277	31.3700008392334	18.168806076049805	2583800
Tue Feb 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.13999938964844	31.43000030517578	30.709999084472656	30.71999931335449	17.792333602905273	2454300
Wed Feb 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.76000022888184	30.899999618530277	30.25	30.420000076293945	17.618589401245117	2671200
Thu Feb 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.549999237060547	30.649999618530277	30.299999237060547	30.459999084472656	17.64175033569336	1698000
Fri Feb 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.530000686645508	30.75	30.299999237060547	30.5	17.66492462158203	2225900


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