S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Aug 06 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.360910876838092	12.66806066916405	11.656713844269412	12.12118434906006	24197800
Fri Aug 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.098706490082302	12.555685964864868	12.008809778609235	12.308467864990234	2454300
Mon Aug 10 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.458297975135142	12.458297975135142	11.694169388381232	11.963862419128418	2421000
Tue Aug 11 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	11.971351504707208	11.986334766096617	11.611761804656098	11.739116668701172	2305400
Wed Aug 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.098703515855505	12.136161660496327	11.73162227166813	11.986331939697266	1451300
Thu Aug 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	11.986337159786036	12.525721817578622	11.986337159786036	12.398366928100586	1150600
Fri Aug 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.360906661598788	12.735479590738146	12.173620197029113	12.435821533203123	637800
Mon Aug 17 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.18860600046678	12.263520887703264	12.13616600806603	12.151147842407228	254400
Tue Aug 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.345926574886567	12.885312645975208	12.248538216985947	12.787922859191896	1446700
Wed Aug 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	12.61562163278622	13.439682706586746	12.585655100085184	13.40222454071045	2070800


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