S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)		0.8360754953400223	0.8275566053292777	0.8299904465675354	314400
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8299904465675353	0.8324245106442144	0.8275566053292777	0.8299904465675354	1396800
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8299901687114515	0.8312073117615384	0.8251222650261444	0.8263391852378845	372000
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8275559544563295	0.8324238559426606	0.8275559544563295	0.8275559544563293	177600
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.823905530963131	0.823905530963131	0.8129525780677795	0.8129525780677795	379200
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8129525735679957	0.8202545421244795	0.8129525735679957	0.8153864145278931	552000
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.815386425575314	0.8178204894065856	0.8105185207511697	0.8178204894065857	177600
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8178204894065856	0.8202545532378572	0.8105185207511697	0.8178204894065857	506400
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8178204894065856	0.8202545532378572	0.8129525845824414	0.8178204894065857	288000
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8178204783261862	0.8214714626044282	0.815386414527893	0.8153864145278931	789600


CREATE TABLE emr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);