Crypto Data Hourly Price Since 2017 To 2023-10

date Date	symbol Symbol	open Open	high High	low Low	close Close	volume_etc Volume ETC	volume_usdt Volume USDT	tradecount Tradecount
2023-10-19 23:00:00	ETCUSDT	14.77	14.82	14.75	14.8	24145.43	357008.2378	595
2023-10-19 22:00:00	ETCUSDT	14.73	14.8	14.73	14.77	17428.9	257368.7858	575
2023-10-19 21:00:00	ETCUSDT	14.8	14.8	14.73	14.73	17544.22	259018.2046	667
2023-10-19 20:00:00	ETCUSDT	14.8	14.84	14.77	14.8	18200.53	269437.7882	783
2023-10-19 19:00:00	ETCUSDT	14.74	14.81	14.72	14.8	8356.09	123388.3253	419
2023-10-19 18:00:00	ETCUSDT	14.74	14.78	14.73	14.74	12364.5	182429.5723	495
2023-10-19 17:00:00	ETCUSDT	14.77	14.78	14.7	14.75	14405.82	212400.4191	711
2023-10-19 16:00:00	ETCUSDT	14.77	14.88	14.74	14.76	32955.21	488080.0039	1414
2023-10-19 15:00:00	ETCUSDT	14.78	14.83	14.71	14.77	21522.07	317759.2097	1115
2023-10-19 14:00:00	ETCUSDT	14.74	14.79	14.7	14.77	17138.74	252614.9718	809


CREATE TABLE binance_etcusdt_1h_1 (
  "date" VARCHAR,
  "symbol" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume_etc" DOUBLE,
  "volume_usdt" DOUBLE,
  "tradecount" BIGINT
);