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

Mkc

@kaggle.artemburenok_sp_500_stock_prices.mkc

399.16 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)	0.859375	0.859375	0.859375	0.859375	0.4100086092948913	236800
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8671879768371582	0.8671879768371582	0.8671879768371582	0.8671879768371582	0.4137364625930786	70400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.875	0.875	0.875	0.875	0.4174632430076599	70400
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.859375	0.859375	0.859375	0.859375	0.4100086092948913	179200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8515629768371582	0.8515629768371582	0.8515629768371582	0.8515629768371582	0.4062815308570862	25600
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8359379768371582	0.8359379768371582	0.8359379768371582	0.8359379768371582	0.3988267183303833	166400
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8007810115814209	0.8007810115814209	0.8007810115814209	0.8007810115814209	0.3820535838603973	358400
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.78125	0.78125	0.78125	0.78125	0.3727349042892456	288000
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.78125	0.78125	0.78125	0.78125	0.3727349042892456	70400
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8046879768371582	0.8046879768371582	0.8046879768371582	0.8046879768371582	0.383917361497879	377600


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