Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jun 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.8	17.4	15.63	16.49	16.49	3371700
Fri Jun 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16.75	17.719999	16.5	17.5	17.5	181700
Mon Jun 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	17.25	17.809999	16.33	17.35	17.35	146300
Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	17.41	17.92	17.379999	17.540001	17.540001	116400
Wed Jun 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16.82	17	15.7	16.045	16.045	1056200
Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16.1	16.190001	13.035	13.63	13.63	580600
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.48	15.18	13.48	15	15	166200
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.85	15.074	14.42	15	15	59100
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.51	17.389999	15.044	16.129999	16.129999	90800
Wed Jul 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16.24	16.24	15.16	15.16	15.16	13000


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