S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Nov 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	16.277707650629193	16.790932326742652	16.277707650629193	16.338987350463867	20946098
Fri Nov 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	16.354308663884506	16.492189296469395	15.894703069208523	16.086204528808594	3243171
Mon Nov 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	16.086200873983508	16.262382804277344	15.335511209359373	15.549994468688965	2823115
Tue Nov 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	15.549994978813777	15.86405926369815	15.052088143191485	15.24359130859375	3565519
Wed Nov 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	15.09039451615023	15.128695859241414	14.722709291807236	15.036773681640623	1266250
Fri Nov 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.975486868087367	15.182309514850813	14.93718728173904	15.052087783813477	333563
Mon Nov 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	15.212951535469088	15.56531542944657	15.067410306006565	15.350833892822266	835458
Tue Nov 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	15.320193994149488	15.320193994149488	15.090391214964471	15.312533378601074	637062
Wed Nov 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	15.43509532918208	16.438566184629614	15.41211348391571	15.963641166687012	679652
Thu Dec 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	16.047905952215853	16.124505146491636	15.588298585351502	15.940664291381836	572521


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