S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Apr 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	23.88651652897105	24.57617168683732	22.98852718577665	24.42531013488769	654700
Fri Apr 13 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24.42530296944283	26.903753377666508	24.36064764608238	26.580476760864254	1685000
Mon Apr 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	26.58047299742218	26.58047299742218	25.85489912950448	26.2571964263916	550200
Tue Apr 17 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	26.149444870931298	26.40088073412577	25.86208724975586	25.86208724975586	179600
Wed Apr 18 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.86208724975586	26.17817844069254	24.784500281016037	25.86208724975586	207100
Thu Apr 19 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.86208724975586	26.73852552794011	25.718408439168144	25.86208724975586	598100
Fri Apr 20 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.93392538477409	26.5804786646879	25.93392538477409	26.09197235107422	149700
Mon Apr 23 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	26.034500331131127	26.034500331131127	25.445416979822934	25.632200241088867	95700
Tue Apr 24 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.862081184661648	25.862081184661648	24.913805093792966	24.964092254638672	124500
Wed Apr 25 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.000011263750647	25.50288561265246	24.78449446863408	24.964092254638672	266200


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