S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Tue Sep 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	19.844705577703976	20.174665424454105	18.006360942615846	18.194908142089844	961200
Wed Sep 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	18.194908185774693	19.35448146703129	18.100635484879604	19.32619857788086	5747900
Thu Sep 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	19.231928261551083	19.401622037086916	18.94910650108263	19.052806854248047	1078200
Fri Sep 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	19.099943078838308	19.84470793165612	19.02452383047528	19.80699920654297	3123300
Mon Oct 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	19.70329662999101	20.50462724996168	19.70329662999101	20.26894187927246	1057900
Tue Oct 04 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	20.212378197758863	21.2116836810314	20.212378197758863	20.891151428222656	1768800
Wed Oct 05 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	20.83458521146498	21.032560041521712	20.504625363233917	20.92885971069336	904300
Thu Oct 06 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	21.30595700604889	21.683053224234342	21.117407997887863	21.28710174560547	1614200
Fri Oct 07 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	20.975995995515017	21.30595584271222	20.55176164938483	20.88172149658203	753400
Mon Oct 10 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	21.00427158325059	21.01369920968036	20.834577903786464	20.938278198242188	538700


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