Crypto Data Hourly Price Since 2017 To 2023-10

date Date	symbol Symbol	open Open	high High	low Low	close Close	volume_shib Volume SHIB	volume_usdt Volume USDT	tradecount Tradecount
Thu Oct 19 2023 23:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000681	0.00000685	0.0000068	0.00000683	47937692711	327304.1782511	742
Thu Oct 19 2023 22:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.0000068	0.00000683	0.00000679	0.00000681	39224629944	267356.25177162	727
Thu Oct 19 2023 21:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000684	0.00000684	0.00000679	0.0000068	110698445542	753888.20311554	1336
Thu Oct 19 2023 20:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.0000068	0.00000687	0.00000679	0.00000684	186694821588	1273718.35318825	2092
Thu Oct 19 2023 19:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000676	0.00000681	0.00000675	0.0000068	60183331704	408267.09700525	968
Thu Oct 19 2023 18:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000677	0.00000679	0.00000675	0.00000675	32705964118	221432.15695954	693
Thu Oct 19 2023 17:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000674	0.00000677	0.00000672	0.00000676	61691653990	415943.23873029	881
Thu Oct 19 2023 16:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000673	0.0000068	0.00000673	0.00000674	164851445341	1113283.44579165	1846
Thu Oct 19 2023 15:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000673	0.00000675	0.0000067	0.00000674	100796540055	678321.39053981	1619
Thu Oct 19 2023 14:00:00 GMT+0000 (Coordinated Universal Time)	SHIBUSDT	0.00000671	0.00000674	0.00000669	0.00000673	73478545771	493459.80948264	1200


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