S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

results for

D

@kaggle.artemburenok_sp_500_stock_prices.d

date Date	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.291666984558105	3.166666984558105	3.166666984558105	0.4382369518280029	375600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.291666984558105	3.166666984558105	3.25	0.4497692883014679	429000
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.291666984558105	3.25	3.25	0.4497692883014679	223200
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.3333330154418945	3.25	3.291666984558105	0.4555358290672302	207300
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.3333330154418945	3.25	3.291666984558105	0.4555358290672302	305700
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.291666984558105	3.2083330154418945	3.2083330154418945	0.4440028667449951	385500
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.25	3.166666984558105	3.2083330154418945	0.4440028667449951	206700
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.291666984558105	3.2083330154418945	3.25	0.4497692883014679	131700
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.2083330154418945	3.0833330154418945	3.125	0.4324706196784973	380400
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	3.2083330154418945	3.125	3.166666984558105	0.4382369518280029	234000


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