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

Hca

@kaggle.artemburenok_sp_500_stock_prices.hca

146.52 KB
2962 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Mar 10 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.200000762939453	31.5	30.700000762939453	31.020000457763672	23.679048538208008	64599900
Fri Mar 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.5	31.290000915527344	30.5	31.1200008392334	23.75539207458496	9531600
Mon Mar 14 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.959999084472656	31.049999237060547	30.56999969482422	30.90999984741211	23.59508514404297	8663800
Tue Mar 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	30.38999938964844	31.5	30.36000061035156	31.34000015258789	23.923322677612305	7121200
Wed Mar 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.25	31.950000762939453	31.1200008392334	31.25	23.85462188720703	6157900
Thu Mar 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.540000915527344	31.93000030517578	31.399999618530277	31.90999984741211	24.358428955078125	3332400
Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	32.11000061035156	33.08000183105469	31.899999618530277	33.060001373291016	25.236284255981445	5463200
Mon Mar 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	33.38999938964844	33.38999938964844	32	32.25	24.617969512939453	3823500
Tue Mar 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	32.369998931884766	32.38999938964844	31.38999938964844	31.8700008392334	24.32789802551269	3943900
Wed Mar 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	31.700000762939453	32.68000030517578	31.5	32.68000030517578	24.94620704650879	4216300


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