S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Oct 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.8177940608599248	1.840098282465568	1.6728166204232435	1.7397292852401731	7776800
Mon Oct 09 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7341532563063835	1.7341532563063835	1.6170557737350464	1.6170557737350464	2759200
Tue Oct 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6059037422647282	1.6951206168349908	1.6059037422647282	1.6393600702285769	2257600
Wed Oct 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6337841551080792	1.6337841551080792	1.5724472210440836	1.583599328994751	3709600
Thu Oct 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.561295562320285	1.561295562320285	1.427470228407118	1.5055350065231323	4552000
Fri Oct 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.4832308914350427	1.5389914512634275	1.4720787794693655	1.5389914512634275	1595200
Mon Oct 16 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5389914271790153	1.5612956507613198	1.527839315387863	1.5445678234100342	1236800
Tue Oct 17 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.538991086337031	1.6616642888711424	1.538991086337031	1.6393600702285769	620000
Wed Oct 18 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.628208110134853	1.639360220478242	1.550143337731127	1.5557197332382202	1392000
Thu Oct 19 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5668718492419196	1.572447564098358	1.5166870121799765	1.5222634077072144	1219200


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