Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Nov 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.98	14.98	14.77	14.89	14.336008	21400
Wed Nov 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.78	14.78	14.56	14.6	14.056798	31300
Thu Nov 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.69	14.7	14.26	14.33	13.796844	8800
Fri Nov 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.62	14.62	14.33	14.4	13.864238	3600
Mon Nov 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	14.1	14.11	13.54	13.65	13.142142	8300
Tue Nov 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	13.7	13.7	13.32	13.47	12.968841	36200
Wed Nov 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	13.2	13.2	12.86	12.9	12.420047	12800
Fri Nov 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	12.94	12.95	12.7	12.7	12.227487	6300
Mon Nov 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	13	13.08	12.8	12.81	12.333395	5300
Tue Nov 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	12.76	12.96	12.75	12.94	12.458558	2800


CREATE TABLE socl (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);