Crypto Data Hourly Price Since 2017 To 2023-10

date Date	symbol Symbol	open Open	high High	low Low	close Close	volume_comp Volume COMP	volume_usdt Volume USDT	tradecount Tradecount
Thu Oct 19 2023 23:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	40.02	40.14	39.92	40.12	785.178	31419.64557	173
Thu Oct 19 2023 22:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	40.07	40.22	39.99	40.02	1031.095	41363.82245	232
Thu Oct 19 2023 21:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	40.25	40.27	39.9	40.12	1801.479	72174.21487	560
Thu Oct 19 2023 20:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	40.08	40.33	40.01	40.25	7423.56	298471.93792	945
Thu Oct 19 2023 19:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.75	40.15	39.75	40.08	2531.542	101276.92259	473
Thu Oct 19 2023 18:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.59	39.98	39.59	39.76	2489.872	99151.57708	456
Thu Oct 19 2023 17:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.59	39.82	39.52	39.58	4000.147	158605.87422	648
Thu Oct 19 2023 16:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.56	39.85	39.51	39.57	3959.082	157071.56969	786
Thu Oct 19 2023 15:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.73	39.87	39.48	39.57	3738.835	148449.9474	679
Thu Oct 19 2023 14:00:00 GMT+0000 (Coordinated Universal Time)	COMPUSDT	39.68	39.73	39.43	39.71	3763.82	148955.23885	566


CREATE TABLE binance_compusdt_1h_1 (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume_comp" DOUBLE,
  "volume_usdt" DOUBLE,
  "tradecount" BIGINT
);