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

Pru

@kaggle.artemburenok_sp_500_stock_prices.pru

238.64 KB
5287 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Dec 13 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	29.100000381469727	30	29	29.299999237060547	16.34859275817871	49466000
Fri Dec 14 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	29.899999618530277	30.100000381469727	29.520000457763672	29.68000030517578	16.560623168945312	9676300
Mon Dec 17 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	29.950000762939453	29.950000762939453	29.399999618530277	29.450000762939453	16.432292938232422	5110900
Tue Dec 18 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	29.5	29.950000762939453	29.38999938964844	29.950000762939453	16.711275100708008	5167700
Wed Dec 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	29.850000381469727	30.190000534057617	29.6200008392334	30.149999618530277	16.822872161865234	3693200
Thu Dec 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	30.25	30.979999542236328	30.1200008392334	30.170000076293945	16.834030151367188	3914200
Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	30.399999618530277	30.989999771118164	30.25	30.989999771118164	17.29157257080078	3429100
Mon Dec 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	30.75	31.489999771118164	30.75	31.450000762939453	17.548242568969727	976900
Wed Dec 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	31.5	32.7400016784668	31.5	32.20000076293945	17.966716766357422	2456300
Thu Dec 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	32.20000076293945	32.970001220703125	31.520000457763672	32.849998474121094	18.32939338684082	4447500


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