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

A

@kaggle.artemburenok_sp_500_stock_prices.a

265.58 KB
5805 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Nov 18 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	32.54649353027344	35.765380859375	28.612302780151367	31.473533630371094	26.929765701293945	62546380
Fri Nov 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	30.713518142700195	30.75822639465332	28.47818374633789	28.880544662475582	24.71112060546875	15234146
Mon Nov 22 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	29.551143646240234	31.473533630371094	28.65700912475586	31.473533630371094	26.929765701293945	6577870
Tue Nov 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	30.40057182312012	31.205293655395508	28.612302780151367	28.612302780151367	24.481597900390625	5975611
Wed Nov 24 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	28.701717376708984	29.99821281433105	28.612302780151367	29.372318267822266	25.13189697265625	4843231
Fri Nov 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	29.23819732666016	29.685264587402344	29.14878463745117	29.46173095703125	25.208402633666992	1729466
Mon Nov 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	29.327611923217773	30.355865478515625	29.014663696289062	30.13233184814453	25.782188415527344	4074751
Tue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	30.042917251586918	30.713518142700195	29.28290367126465	30.177038192749023	25.820446014404297	4310034
Wed Dec 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	30.177038192749023	31.0711727142334	29.95350456237793	30.713518142700195	26.27947425842285	2957329
Thu Dec 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	31.29470634460449	32.1888427734375	30.8923454284668	31.56294631958008	27.006267547607425	3069868


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