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

Mmc

@kaggle.artemburenok_sp_500_stock_prices.mmc

424.47 KB
12565 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.9375	2.9375	2.9375	2.9375	0.9469833374023438	164400
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.9583330154418945	2.9583330154418945	2.9583330154418945	2.9583330154418945	0.9536997079849244	188400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.9583330154418945	2.9583330154418945	2.9583330154418945	2.9583330154418945	0.9536997079849244	222000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.8958330154418945	2.8958330154418945	2.8958330154418945	2.8958330154418945	0.9335508942604064	61200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.791666984558105	2.791666984558105	2.791666984558105	2.791666984558105	0.8999705910682678	368400
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.7708330154418945	2.7708330154418945	2.7708330154418945	2.7708330154418945	0.8932533264160156	414000
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.625	2.625	2.625	2.625	0.8462405204772949	444000
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.666666984558105	2.666666984558105	2.666666984558105	2.666666984558105	0.8596735000610352	109200
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.8020830154418945	2.8020830154418945	2.8020830154418945	2.8020830154418945	0.9033286571502686	135600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	2.8958330154418945	2.8958330154418945	2.8958330154418945	2.8958330154418945	0.9335508942604064	202800


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