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

Mpc

@kaggle.artemburenok_sp_500_stock_prices.mpc

141.03 KB
2888 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Jun 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	19.375	19.575000762939453	18.420000076293945	18.625	13.120157241821287	1675400
Mon Jun 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	18.34499931335449	18.975000381469727	18.295000076293945	18.825000762939453	13.261048316955566	895200
Tue Jun 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	19.170000076293945	19.9950008392334	18.850000381469727	19.350000381469727	13.630879402160645	4151800
Wed Jun 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	19.5	20.48500061035156	19.350000381469727	20.03499984741211	14.113417625427246	3695200
Thu Jun 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	20.334999084472656	21	20.09000015258789	20.700000762939453	14.581868171691896	3025600
Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	20.600000381469727	23.71500015258789	20.5	21.100000381469727	14.863649368286133	8334200
Tue Jul 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.104999542236328	21.5	20.825000762939453	21.104999542236328	14.867167472839355	11823000
Wed Jul 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	20.799999237060547	21.125	20.5049991607666	20.94499969482422	14.754453659057615	10983000
Thu Jul 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.09499931335449	21.6299991607666	20.854999542236328	20.88999938964844	14.715709686279297	16707600
Fri Jul 08 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	20.399999618530277	21.299999237060547	20.26000022888184	20.70499992370605	14.585391998291016	16417000


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