S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Aug 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	50.050048828125	52.08208084106445	48.02802658081055	50.22021865844727	44659096
Fri Aug 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	50.55555725097656	54.59459686279297	50.30030059814453	54.20920944213867	22834343
Mon Aug 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	55.4304313659668	56.79679870605469	54.5795783996582	54.75475311279297	18256126
Tue Aug 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	55.67567443847656	55.85585784912109	51.83683776855469	52.48748779296875	15247337
Wed Aug 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	52.53253173828125	54.05405426025391	51.99199295043945	53.05305480957031	9188602
Thu Aug 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	52.52752685546875	54.029029846191406	52.38238143920898	54.009010314941406	7094898
Fri Aug 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	54.104103088378906	54.36436462402344	52.89789962768555	53.12812805175781	6211782
Mon Aug 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	52.69269180297852	52.79779815673828	51.05605697631836	51.05605697631836	5196798
Tue Aug 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	51.201202392578125	51.90690612792969	51.13113021850586	51.236236572265625	4917877
Wed Sep 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	51.40140151977539	51.53653717041016	49.884883880615234	50.175174713134766	9138253


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