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

Hum

@kaggle.artemburenok_sp_500_stock_prices.hum

394.26 KB
10326 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Dec 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	9.82638931274414	9.930556297302246	9.722222328186035	9.722222328186035	1.971137285232544	68040
Mon Jan 04 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.965277671813965	10.104166984558104	9.791666984558104	10.069443702697754	2.0415356159210205	106560
Tue Jan 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	10	10.17361068725586	9.82638931274414	9.86111068725586	1.9992966651916504	240840
Wed Jan 06 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.82638931274414	9.930556297302246	9.6875	9.791666984558104	1.9852169752120967	239040
Thu Jan 07 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.756943702697754	9.791666984558104	9.722222328186035	9.791666984558104	1.9852169752120967	162720
Fri Jan 08 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.82638931274414	9.895833015441896	9.756943702697754	9.86111068725586	1.9992966651916504	210960
Mon Jan 11 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.82638931274414	9.930556297302246	9.6875	9.6875	1.964098334312439	218160
Tue Jan 12 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.652777671813965	9.6875	9.583333015441896	9.618056297302246	1.9500184059143064	198360
Wed Jan 13 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.618056297302246	9.652777671813965	9.583333015441896	9.618056297302246	1.9500184059143064	465120
Thu Jan 14 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	9.479166984558104	9.54861068725586	9.375	9.479166984558104	1.9218595027923584	288360


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