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

Wtw

@kaggle.artemburenok_sp_500_stock_prices.wtw

231.44 KB
5412 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Jun 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	43.70861053466797	45.16556167602539	42.38410568237305	43.9735107421875	27.73384094238281	3894441
Wed Jun 13 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	43.84106063842773	44.23841094970703	43.70861053466797	43.84106063842773	27.65028381347656	758020
Thu Jun 14 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	43.70861053466797	43.70861053466797	42.38410568237305	42.91390609741211	27.065561294555664	501093
Fri Jun 15 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	42.78145599365234	43.5761604309082	42.38410568237305	43.5761604309082	27.48322105407715	382823
Mon Jun 18 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	45.033111572265625	46.092716217041016	43.84106063842773	45.13907241821289	28.468942642211918	358398
Tue Jun 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	45.033111572265625	45.96026611328125	44.3708610534668	45.96026611328125	28.98688125610352	232804
Wed Jun 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	46.092716217041016	49.006622314453125	46.092716217041016	47.15231704711914	29.738683700561523	176179
Thu Jun 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	47.15231704711914	47.6821174621582	47.019866943359375	47.15231704711914	29.738683700561523	79124
Fri Jun 22 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	47.09933853149414	47.09933853149414	45.96026611328125	46.30463409423828	29.204051971435547	109852
Mon Jun 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	45.69536590576172	47.6821174621582	43.70861053466797	46.75496673583984	29.48808479309082	142582


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