Top-100-USA-Companies

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Aug 06 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.5	16.91	15.56	16.18	12.221672	24197800
Fri Aug 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.15	16.76	16.030001	16.43	12.410511	2454300
Mon Aug 10 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.629999	16.629999	15.61	15.97	12.063046	2421000
Tue Aug 11 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	15.98	16	15.5	15.67	11.836437	2305400
Wed Aug 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.15	16.200001	15.66	16	12.08571	1451300
Thu Aug 13 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16	16.719999	16	16.549999	12.501151	1150600
Fri Aug 14 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.5	17	16.25	16.6	12.53892	637800
Mon Aug 17 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.27	16.370001	16.200001	16.219999	12.251886	254400
Tue Aug 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.48	17.200001	16.35	17.07	12.89394	1446700
Wed Aug 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	16.84	17.940001	16.799999	17.889999	13.51333	2070800


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