S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Nov 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	11.20981178754557	15.482728817302243	11.20981178754557	15.37722396850586	8150300
Mon Nov 08 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	15.060713902809796	16.59931580713923	14.506817955106117	16.44106101989746	1113400
Tue Nov 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	16.476231247567075	17.232344860281152	15.227765403685906	16.326766967773438	521600
Wed Nov 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	16.133342711668693	18.67423369915853	15.843206376339204	17.715904235839844	709500
Thu Nov 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	18.199464733059276	21.461300240738463	17.9093284165354	18.463224411010746	1757100
Fri Nov 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19.474302111998245	19.78202280208593	18.463221281946865	18.81490135192871	580900
Mon Nov 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19.034709419291488	20.309552082876586	18.10275643202455	18.999542236328125	638900
Tue Nov 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19.509474464908365	19.75564971968196	18.41926521349388	19.518266677856445	457500
Wed Nov 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19.166594840225365	20.441437872973356	19.166594840225365	19.342435836791992	442500
Thu Nov 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19.175370233361644	19.333626656029303	18.03240978933916	18.322546005249023	273900


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