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

Lyv

@kaggle.artemburenok_sp_500_stock_prices.lyv

181.69 KB
4274 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Dec 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	11	11.050000190734863	10.550000190734863	10.850000381469728	10.850000381469728	5796900
Thu Dec 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10.600000381469728	11.119999885559082	10.59000015258789	10.600000381469728	10.600000381469728	4152500
Fri Dec 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10.899999618530272	12.779999732971191	10.899999618530272	11.949999809265137	11.949999809265137	8844700
Tue Dec 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	12.199999809265137	12.789999961853027	12.130000114440918	12.5	12.5	3324100
Wed Dec 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	12.25	14	12.25	13.300000190734863	13.300000190734863	3187700
Thu Dec 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	13.800000190734863	13.829999923706056	13.210000038146973	13.210000038146973	13.210000038146973	1092100
Fri Dec 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	13.649999618530272	13.649999618530272	12.65999984741211	13.100000381469728	13.100000381469728	1208400
Tue Jan 03 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	12.899999618530272	13.5	12.8100004196167	13.5	13.5	1875500
Wed Jan 04 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	13.470000267028809	13.850000381469728	13	13	13	2342000
Thu Jan 05 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	13.300000190734863	13.3100004196167	12.949999809265137	13	13	2880600


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