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

Mhk

@kaggle.artemburenok_sp_500_stock_prices.mhk

314.73 KB
7734 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Apr 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.6666669845581055	7	6.6666669845581055	6.833333015441895	6.833333015441895	4215825
Thu Apr 02 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.833333015441895	7	6.777778148651123	6.777778148651123	6.777778148651123	439875
Fri Apr 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.777778148651123	6.888888835906982	6.777778148651123	6.777778148651123	6.777778148651123	553275
Mon Apr 06 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.777778148651123	6.888888835906982	6.777778148651123	6.777778148651123	6.777778148651123	389250
Tue Apr 07 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.777778148651123	7	6.777778148651123	6.777778148651123	6.777778148651123	497250
Wed Apr 08 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.777778148651123	6.777778148651123	6.444444179534912	6.444444179534912	6.444444179534912	220950
Thu Apr 09 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.444444179534912	6.777778148651123	6.444444179534912	6.777778148651123	6.777778148651123	284850
Fri Apr 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.6666669845581055	6.777778148651123	6.555555820465088	6.777778148651123	6.777778148651123	114300
Mon Apr 13 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.6666669845581055	6.777778148651123	6.6666669845581055	6.722221851348877	6.722221851348877	38475
Tue Apr 14 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	6.6666669845581055	6.888888835906982	6.6666669845581055	6.888888835906982	6.888888835906982	263250


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