S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Nov 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.97236390292319	46.20338080695798	43.88397264146551	44.79879760742188	587100
Tue Nov 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.27007001567179	45.27930913998981	41.86025856114627	42.32229232788086	1682000
Wed Nov 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	42.48863269711006	42.50711447423392	40.649739936268055	41.25962448120117	1106900
Thu Nov 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41.12101493071956	41.72166037904893	39.77187685990075	40.46492767333984	730200
Fri Nov 22 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	40.56656827366041	40.75137897009302	39.96592293514018	40.64973449707031	947600
Mon Nov 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	40.9177151099744	42.15596592303786	40.38175769687801	40.82530975341797	727300
Tue Nov 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41.58304458930679	41.58304458930679	39.7718728265373	39.91972351074219	873700
Wed Nov 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	40.24314280920888	40.24314280920888	39.27287254544664	39.95668411254883	1153300
Fri Nov 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	39.5038894427728	40.52036238099264	39.5038894427728	39.95668411254883	949900
Mon Dec 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	39.80883889375323	40.35403546210763	38.36729198790772	39.8642807006836	5130700


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