S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume	dividends Dividends
Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)		0.4226769208908081	0.417790344494934	0.4226769208908081	318600
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4226771144618118	0.4269528275150488	0.4214553833007812	0.4214553833007812	140400
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4226806808448565	0.4232933223953207	0.4085912501556062	0.4165549278259277	469800	0.00463
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4128794074058532	0.4128794074058532	0.4116544397345164	0.4128794074058532	140400
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4128792207565629	0.4134918620499749	0.4092037200122712	0.4104289710521698	178200
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4104289710521698	0.4116542536389939	0.4079787213477767	0.4104289710521698	432000
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4104290356083642	0.4116543183879125	0.4098164257655206	0.4110416769981384	199800
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.411041605532759	0.4116542468160167	0.4092037132299105	0.4098163545131683	183600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4104291724852357	0.4147173166275024	0.4104291724852357	0.4147173166275024	415800
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	0.415942026772753	0.4202301679343415	0.415942026772753	0.4190049171447754	216000


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