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

Pwr

@kaggle.artemburenok_sp_500_stock_prices.pwr

243.02 KB
6251 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Feb 12 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.3333330154418945	7.8333330154418945	7.3333330154418945	7.5	7.391870021820068	3903750
Fri Feb 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.5833330154418945	7.6666669845581055	7.4166669845581055	7.5	7.391870021820068	504000
Tue Feb 17 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.75	7.9166669845581055	7.75	7.8333330154418945	7.720397472381592	132600
Wed Feb 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.9166669845581055	8.333333015441895	7.875	8.333333015441895	8.213189125061035	140700
Thu Feb 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	8.416666984558105	8.666666984558105	8.166666984558105	8.166666984558105	8.04892635345459	235050
Fri Feb 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	8.083333015441895	8.166666984558105	7.5833330154418945	7.7916669845581055	7.6793317794799805	204750
Mon Feb 23 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.8333330154418945	7.9166669845581055	7.625	7.9166669845581055	7.802529811859131	60600
Tue Feb 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.875	7.9166669845581055	7.5416669845581055	7.6666669845581055	7.556133270263672	261300
Wed Feb 25 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.75	7.75	7.5	7.6666669845581055	7.556133270263672	129000
Thu Feb 26 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	7.5833330154418945	8.083333015441895	7.5833330154418945	7.9583330154418945	7.843594551086426	87000


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