S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Jun 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.333333015441895	6.336667060852051	6.033332824707031	6.116666793823242	35097600
Mon Jun 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.083333015441895	6.126667022705078	6.053332805633545	6.066667079925537	2313600
Tue Jun 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.070000171661377	6.25	6.070000171661377	6.25	2499600
Wed Jun 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.25	6.366666793823242	6.25	6.333333015441895	2810100
Thu Jun 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.353332996368408	6.366666793823242	6.266666889190674	6.349999904632568	1390200
Fri Jun 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.349999904632568	6.396667003631592	6.333333015441895	6.343332767486572	708300
Mon Jun 21 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.329999923706055	6.366666793823242	6.300000190734863	6.363333225250244	508500
Tue Jun 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.329999923706055	6.363333225250244	6.300000190734863	6.353332996368408	1125900
Wed Jun 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.283332824707031	6.296667098999023	6.156667232513428	6.296667098999023	1033500
Thu Jun 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.266666889190674	6.349999904632568	6.25	6.333333015441895	857700


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