Top-100-USA-Companies

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Jan 22 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.539063	0.679688	0.539063	0.632813	0.504442	168022400
Thu Jan 23 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.65625	0.710938	0.632813	0.6875	0.548036	38368000
Fri Jan 24 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.695313	0.726563	0.671875	0.695313	0.554264	12044800
Mon Jan 27 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.726563	0.75	0.695313	0.75	0.597857	10716800
Tue Jan 28 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.742188	0.757813	0.710938	0.734375	0.585402	19913600
Wed Jan 29 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.710938	0.734375	0.679688	0.679688	0.541808	13238400
Thu Jan 30 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6875	0.695313	0.609375	0.609375	0.485759	10848000
Fri Jan 31 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.625	0.648438	0.609375	0.648438	0.516897	2496000
Mon Feb 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.65625	0.65625	0.632813	0.640625	0.51067	2320000
Tue Feb 04 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.648438	0.679688	0.648438	0.679688	0.541808	2499200


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