S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Nov 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	21.111215231720568	26.11365606300127	20.248408553789147	23.956640243530277	11770500
Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	23.846490301218896	23.846490301218896	21.661939573576948	22.910253524780277	1242900
Mon Nov 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	22.68078131036996	23.635375976562504	22.515564618804	23.6353759765625	469500
Tue Nov 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	23.33248085202479	26.81124084502693	23.1856203734699	25.07645034790039	522200
Wed Nov 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	24.782727580154276	24.902051053744174	23.80977654313357	24.461469650268555	167500
Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	25.05809312330831	26.003509015042003	24.61751167405409	25.14988136291504	100700
Mon Nov 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	25.69143010383223	27.06824844862955	25.269206651770943	25.517032623291016	438300
Tue Nov 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	25.9117224727489	26.38901994939658	24.12185956139284	24.764373779296875	305800
Wed Nov 28 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	24.892869709189974	25.351809033284287	24.48900261378689	25.058086395263672	273600
Thu Nov 29 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	24.424751388528023	25.69142315271391	24.415572391960385	25.058086395263672	110600


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