S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Oct 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	16.20792117890503	16.626308381224852	15.916870117187502	15.9168701171875	6467100
Mon Oct 15 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	15.962345009634408	16.21701553712548	15.916868935168628	16.14425277709961	633100
Tue Oct 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	15.98054032333125	16.32616482517534	15.689489206916116	16.180639266967773	180300
Wed Oct 17 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	16.098779678344727	16.43530685511794	15.916871877255549	16.098779678344727	121000
Thu Oct 18 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	16.00782577780014	16.25340078883012	15.935063004324736	16.098779678344727	146100
Fri Oct 19 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	16.116968917271812	16.189731690054927	15.835013389587402	15.835013389587402	298100
Mon Oct 22 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	15.916872418765486	15.925967982609524	15.398437423265351	15.489391326904297	359800
Tue Oct 23 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	15.32567252593524	15.73496243345446	15.234718634886132	15.580341339111328	166100
Wed Oct 24 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	15.389340984445608	15.889584823815827	15.389340984445608	15.816822052001951	158200
Thu Oct 25 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	16.353449074470713	16.353449074470713	14.779952960282236	15.489391326904297	206900


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