S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.94635772705078	20.813590671705164	19.599464880012142	19.94635772705078	56477500
Fri Aug 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.85963410176223	19.94635772705078	19.66017092147946	19.94635772705078	6458900
Mon Aug 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.03308135233933	20.059097282045	19.85963410176223	19.94635772705078	3455900
Tue Aug 05 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.93768519911037	19.955030254991197	19.66017092147946	19.94635772705078	4450200
Wed Aug 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.7729082143976	19.92901039123535	19.6601686723011	19.92901039123535	6993400
Thu Aug 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.850960524837102	19.94635667302505	19.77290943161342	19.885650634765625	3186900
Fri Aug 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.885651007942663	19.972374630275947	19.772909802674743	19.902996063232425	2855000
Mon Aug 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.85963305231924	19.885650634765625	19.77290943161342	19.885650634765625	1767500
Tue Aug 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.850961573821817	19.94635772705078	19.798928060294912	19.94635772705078	1549700
Wed Aug 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.94635487413968	20.145818025893394	19.84228620785516	20.10245704650879	1659100


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