S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Mar 10 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	23.93573275076541	24.1658834362822	23.55214729939585	23.79764175415039	64599900
Fri Mar 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	23.39871626614696	24.004782078357472	23.39871626614696	23.87436294555664	9531600
Mon Mar 14 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	23.75161480280488	23.82066031377627	23.45241856410394	23.7132568359375	8663800
Tue Mar 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	23.31432919061317	24.165889577295275	23.29131499417057	24.043142318725582	7121200
Wed Mar 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	23.97409439086914	24.51111469052965	23.874362802038668	23.97409439086914	6157900
Thu Mar 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	24.196576219564804	24.49577246824235	24.08917127488201	24.48042869567871	3332400
Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	24.633859813807664	25.37801657605699	24.472753152488615	25.362672805786133	5463200
Mon Mar 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	25.61584275018229	25.61584275018229	24.5494753815407	24.741268157958984	3823500
Tue Mar 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	24.833327352434612	24.8486711254106	24.081500035763963	24.449743270874023	3943900
Wed Mar 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	24.31932255789106	25.071149826049805	24.165887764557077	25.071149826049805	4216300


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