Bitcoin Historical Prices Binance API

CREATE TABLE btcusdt_1h_2019_09 (
  "n_1567296000000" BIGINT  -- 1567296000000,
  "n_9588_74000000" DOUBLE  -- 9588.74000000,
  "n_9630_00000000" DOUBLE  -- 9630.00000000,
  "n_9579_34000000" DOUBLE  -- 9579.34000000,
  "n_9617_06000000" DOUBLE  -- 9617.06000000,
  "n_546_96041500" DOUBLE  -- 546.96041500,
  "n_1567299599999" BIGINT  -- 1567299599999,
  "n_5257943_07927197" DOUBLE  -- 5257943.07927197,
  "n_7428" BIGINT  -- 7428,
  "n_261_13165600" DOUBLE  -- 261.13165600,
  "n_2510479_64800076" DOUBLE  -- 2510479.64800076,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2019_10 (
  "n_1569888000000" BIGINT  -- 1569888000000,
  "n_8289_97000000" DOUBLE  -- 8289.97000000,
  "n_8310_08000000" DOUBLE  -- 8310.08000000,
  "n_8188_00000000" DOUBLE  -- 8188.00000000,
  "n_8199_66000000" DOUBLE  -- 8199.66000000,
  "n_1870_17480300" DOUBLE  -- 1870.17480300,
  "n_1569891599999" BIGINT  -- 1569891599999,
  "n_15417374_66360515" DOUBLE  -- 15417374.66360515,
  "n_13787" BIGINT  -- 13787,
  "n_1088_26623300" DOUBLE  -- 1088.26623300,
  "n_8979985_99248479" DOUBLE  -- 8979985.99248479,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2019_11 (
  "n_1572566400000" BIGINT  -- 1572566400000,
  "n_9140_86000000" DOUBLE  -- 9140.86000000,
  "n_9144_70000000" DOUBLE  -- 9144.70000000,
  "n_9098_28000000" DOUBLE  -- 9098.28000000,
  "n_9125_52000000" DOUBLE  -- 9125.52000000,
  "n_1312_05812600" DOUBLE  -- 1312.05812600,
  "n_1572569999999" BIGINT  -- 1572569999999,
  "n_11962824_54910539" DOUBLE  -- 11962824.54910539,
  "n_16105" BIGINT  -- 16105,
  "n_694_98211300" DOUBLE  -- 694.98211300,
  "n_6336723_87239890" DOUBLE  -- 6336723.87239890,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2019_12 (
  "n_1575158400000" BIGINT  -- 1575158400000,
  "n_7540_63000000" DOUBLE  -- 7540.63000000,
  "n_7541_85000000" DOUBLE  -- 7541.85000000,
  "n_7455_08000000" DOUBLE  -- 7455.08000000,
  "n_7480_61000000" DOUBLE  -- 7480.61000000,
  "n_1877_47477700" DOUBLE  -- 1877.47477700,
  "n_1575161999999" BIGINT  -- 1575161999999,
  "n_14077183_14591298" DOUBLE  -- 14077183.14591298,
  "n_13179" BIGINT  -- 13179,
  "n_982_89331200" DOUBLE  -- 982.89331200,
  "n_7369242_34981727" DOUBLE  -- 7369242.34981727,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_01 (
  "n_1577836800000" BIGINT  -- 1577836800000,
  "n_7195_24000000" DOUBLE  -- 7195.24000000,
  "n_7196_25000000" DOUBLE  -- 7196.25000000,
  "n_7175_46000000" DOUBLE  -- 7175.46000000,
  "n_7177_02000000" DOUBLE  -- 7177.02000000,
  "n_511_81490100" DOUBLE  -- 511.81490100,
  "n_1577840399999" BIGINT  -- 1577840399999,
  "n_3675856_57948543" DOUBLE  -- 3675856.57948543,
  "n_7640" BIGINT  -- 7640,
  "n_226_15312600" DOUBLE  -- 226.15312600,
  "n_1624289_18965037" DOUBLE  -- 1624289.18965037,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_02 (
  "n_1580515200000" BIGINT  -- 1580515200000,
  "n_9351_71000000" DOUBLE  -- 9351.71000000,
  "n_9394_08000000" DOUBLE  -- 9394.08000000,
  "n_9341_17000000" DOUBLE  -- 9341.17000000,
  "n_9383_07000000" DOUBLE  -- 9383.07000000,
  "n_848_81719700" DOUBLE  -- 848.81719700,
  "n_1580518799999" BIGINT  -- 1580518799999,
  "n_7950986_77524696" DOUBLE  -- 7950986.77524696,
  "n_12119" BIGINT  -- 12119,
  "n_465_17274000" DOUBLE  -- 465.17274000,
  "n_4357468_00431309" DOUBLE  -- 4357468.00431309,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_03 (
  "n_1583020800000" BIGINT  -- 1583020800000,
  "n_8523_61000000" DOUBLE  -- 8523.61000000,
  "n_8613_57000000" DOUBLE  -- 8613.57000000,
  "n_8511_11000000" DOUBLE  -- 8511.11000000,
  "n_8547_25000000" DOUBLE  -- 8547.25000000,
  "n_1952_74052000" DOUBLE  -- 1952.74052000,
  "n_1583024399999" BIGINT  -- 1583024399999,
  "n_16737893_23371445" DOUBLE  -- 16737893.23371445,
  "n_22876" BIGINT  -- 22876,
  "n_899_85114400" DOUBLE  -- 899.85114400,
  "n_7713994_59225310" DOUBLE  -- 7713994.59225310,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_04 (
  "n_1585699200000" BIGINT  -- 1585699200000,
  "n_6412_14000000" DOUBLE  -- 6412.14000000,
  "n_6426_52000000" DOUBLE  -- 6426.52000000,
  "n_6239_34000000" DOUBLE  -- 6239.34000000,
  "n_6305_12000000" DOUBLE  -- 6305.12000000,
  "n_9061_28094500" DOUBLE  -- 9061.28094500,
  "n_1585702799999" BIGINT  -- 1585702799999,
  "n_57230360_57684213" DOUBLE  -- 57230360.57684213,
  "n_54364" BIGINT  -- 54364,
  "n_3742_08493800" DOUBLE  -- 3742.08493800,
  "n_23630004_37370211" DOUBLE  -- 23630004.37370211,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_05 (
  "n_1588291200000" BIGINT  -- 1588291200000,
  "n_8620_00000000" DOUBLE  -- 8620.00000000,
  "n_8739_01000000" DOUBLE  -- 8739.01000000,
  "n_8613_56000000" DOUBLE  -- 8613.56000000,
  "n_8707_51000000" DOUBLE  -- 8707.51000000,
  "n_3459_68866500" DOUBLE  -- 3459.68866500,
  "n_1588294799999" BIGINT  -- 1588294799999,
  "n_30048334_63131534" DOUBLE  -- 30048334.63131534,
  "n_35104" BIGINT  -- 35104,
  "n_1756_77408300" DOUBLE  -- 1756.77408300,
  "n_15257342_04754400" DOUBLE  -- 15257342.04754400,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_06 (
  "n_1590969600000" BIGINT  -- 1590969600000,
  "n_9448_27000000" DOUBLE  -- 9448.27000000,
  "n_9508_57000000" DOUBLE  -- 9508.57000000,
  "n_9421_67000000" DOUBLE  -- 9421.67000000,
  "n_9498_31000000" DOUBLE  -- 9498.31000000,
  "n_1742_12591700" DOUBLE  -- 1742.12591700,
  "n_1590973199999" BIGINT  -- 1590973199999,
  "n_16506416_24100491" DOUBLE  -- 16506416.24100491,
  "n_26648" BIGINT  -- 26648,
  "n_950_04793300" DOUBLE  -- 950.04793300,
  "n_9001264_67142507" DOUBLE  -- 9001264.67142507,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_07 (
  "n_1593561600000" BIGINT  -- 1593561600000,
  "n_9138_08000000" DOUBLE  -- 9138.08000000,
  "n_9138_16000000" DOUBLE  -- 9138.16000000,
  "n_9080_10000000" DOUBLE  -- 9080.10000000,
  "n_9122_00000000" DOUBLE  -- 9122.00000000,
  "n_1737_64189900" DOUBLE  -- 1737.64189900,
  "n_1593565199999" BIGINT  -- 1593565199999,
  "n_15831394_79607631" DOUBLE  -- 15831394.79607631,
  "n_17535" BIGINT  -- 17535,
  "n_752_80150200" DOUBLE  -- 752.80150200,
  "n_6859354_46405732" DOUBLE  -- 6859354.46405732,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_08 (
  "n_1596240000000" BIGINT  -- 1596240000000,
  "n_11335_46000000" DOUBLE  -- 11335.46000000,
  "n_11389_00000000" DOUBLE  -- 11389.00000000,
  "n_11220_00000000" DOUBLE  -- 11220.00000000,
  "n_11248_35000000" DOUBLE  -- 11248.35000000,
  "n_3192_17148800" DOUBLE  -- 3192.17148800,
  "n_1596243599999" BIGINT  -- 1596243599999,
  "n_36049804_85008039" DOUBLE  -- 36049804.85008039,
  "n_45488" BIGINT  -- 45488,
  "n_1260_66960900" DOUBLE  -- 1260.66960900,
  "n_14233394_22436501" DOUBLE  -- 14233394.22436501,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_09 (
  "n_1598918400000" BIGINT  -- 1598918400000,
  "n_11649_51000000" DOUBLE  -- 11649.51000000,
  "n_11668_50000000" DOUBLE  -- 11668.50000000,
  "n_11515_00000000" DOUBLE  -- 11515.00000000,
  "n_11612_21000000" DOUBLE  -- 11612.21000000,
  "n_4218_96656600" DOUBLE  -- 4218.96656600,
  "n_1598921999999" BIGINT  -- 1598921999999,
  "n_48937901_36691901" DOUBLE  -- 48937901.36691901,
  "n_65073" BIGINT  -- 65073,
  "n_1722_18746100" DOUBLE  -- 1722.18746100,
  "n_19973233_60366496" DOUBLE  -- 19973233.60366496,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_10 (
  "n_1601510400000" BIGINT  -- 1601510400000,
  "n_10776_59000000" DOUBLE  -- 10776.59000000,
  "n_10826_19000000" DOUBLE  -- 10826.19000000,
  "n_10776_59000000_1" DOUBLE  -- 10776.59000000.1,
  "n_10788_06000000" DOUBLE  -- 10788.06000000,
  "n_2128_75953100" DOUBLE  -- 2128.75953100,
  "n_1601513999999" BIGINT  -- 1601513999999,
  "n_22996705_85056913" DOUBLE  -- 22996705.85056913,
  "n_26789" BIGINT  -- 26789,
  "n_1031_89931500" DOUBLE  -- 1031.89931500,
  "n_11146918_38907718" DOUBLE  -- 11146918.38907718,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_11 (
  "n_1604188800000" BIGINT  -- 1604188800000,
  "n_13791_00000000" DOUBLE  -- 13791.00000000,
  "n_13895_00000000" DOUBLE  -- 13895.00000000,
  "n_13660_00000000" DOUBLE  -- 13660.00000000,
  "n_13725_95000000" DOUBLE  -- 13725.95000000,
  "n_3504_28867800" DOUBLE  -- 3504.28867800,
  "n_1604192399999" BIGINT  -- 1604192399999,
  "n_48255602_57387439" DOUBLE  -- 48255602.57387439,
  "n_50886" BIGINT  -- 50886,
  "n_1504_25543100" DOUBLE  -- 1504.25543100,
  "n_20721556_04279065" DOUBLE  -- 20721556.04279065,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2020_12 (
  "n_1606780800000" BIGINT  -- 1606780800000,
  "n_19695_87000000" DOUBLE  -- 19695.87000000,
  "n_19720_00000000" DOUBLE  -- 19720.00000000,
  "n_19479_80000000" DOUBLE  -- 19479.80000000,
  "n_19565_47000000" DOUBLE  -- 19565.47000000,
  "n_4570_36151800" DOUBLE  -- 4570.36151800,
  "n_1606784399999" BIGINT  -- 1606784399999,
  "n_89601884_00766336" DOUBLE  -- 89601884.00766336,
  "n_80922" BIGINT  -- 80922,
  "n_2283_53179500" DOUBLE  -- 2283.53179500,
  "n_44768525_40250521" DOUBLE  -- 44768525.40250521,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_01 (
  "n_1609459200000" BIGINT  -- 1609459200000,
  "n_28923_63000000" DOUBLE  -- 28923.63000000,
  "n_29031_34000000" DOUBLE  -- 29031.34000000,
  "n_28690_17000000" DOUBLE  -- 28690.17000000,
  "n_28995_13000000" DOUBLE  -- 28995.13000000,
  "n_2311_81144500" DOUBLE  -- 2311.81144500,
  "n_1609462799999" BIGINT  -- 1609462799999,
  "n_66768830_34010008" DOUBLE  -- 66768830.34010008,
  "n_58389" BIGINT  -- 58389,
  "n_1215_35923800" DOUBLE  -- 1215.35923800,
  "n_35103542_78288276" DOUBLE  -- 35103542.78288276,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_02 (
  "n_1612137600000" BIGINT  -- 1612137600000,
  "n_33092_97000000" DOUBLE  -- 33092.97000000,
  "n_33106_33000000" DOUBLE  -- 33106.33000000,
  "n_32296_16000000" DOUBLE  -- 32296.16000000,
  "n_32546_27000000" DOUBLE  -- 32546.27000000,
  "n_4383_92612200" DOUBLE  -- 4383.92612200,
  "n_1612141199999" BIGINT  -- 1612141199999,
  "n_142737162_71050398" DOUBLE  -- 142737162.71050398,
  "n_98763" BIGINT  -- 98763,
  "n_2074_60006900" DOUBLE  -- 2074.60006900,
  "n_67502334_30717597" DOUBLE  -- 67502334.30717597,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_03 (
  "n_1614556800000" BIGINT  -- 1614556800000,
  "n_45134_11000000" DOUBLE  -- 45134.11000000,
  "n_46571_30000000" DOUBLE  -- 46571.30000000,
  "n_44950_53000000" DOUBLE  -- 44950.53000000,
  "n_46217_19000000" DOUBLE  -- 46217.19000000,
  "n_4899_57483300" DOUBLE  -- 4899.57483300,
  "n_1614560399999" BIGINT  -- 1614560399999,
  "n_225513040_97302689" DOUBLE  -- 225513040.97302689,
  "n_98570" BIGINT  -- 98570,
  "n_2546_12383200" DOUBLE  -- 2546.12383200,
  "n_117249522_87670990" DOUBLE  -- 117249522.87670990,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_04 (
  "n_1617235200000" BIGINT  -- 1617235200000,
  "n_58739_46000000" DOUBLE  -- 58739.46000000,
  "n_59240_07000000" DOUBLE  -- 59240.07000000,
  "n_58720_82000000" DOUBLE  -- 58720.82000000,
  "n_59221_95000000" DOUBLE  -- 59221.95000000,
  "n_1834_68560800" DOUBLE  -- 1834.68560800,
  "n_1617238799999" BIGINT  -- 1617238799999,
  "n_108266228_54735337" DOUBLE  -- 108266228.54735337,
  "n_68073" BIGINT  -- 68073,
  "n_913_28839100" DOUBLE  -- 913.28839100,
  "n_53894606_46228596" DOUBLE  -- 53894606.46228596,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_05 (
  "n_1619827200000" BIGINT  -- 1619827200000,
  "n_57697_25000000" DOUBLE  -- 57697.25000000,
  "n_58088_00000000" DOUBLE  -- 58088.00000000,
  "n_57421_05000000" DOUBLE  -- 57421.05000000,
  "n_57811_42000000" DOUBLE  -- 57811.42000000,
  "n_3480_44951600" DOUBLE  -- 3480.44951600,
  "n_1619830799999" BIGINT  -- 1619830799999,
  "n_201401665_20246092" DOUBLE  -- 201401665.20246092,
  "n_120522" BIGINT  -- 120522,
  "n_1653_36720000" DOUBLE  -- 1653.36720000,
  "n_95686049_09968617" DOUBLE  -- 95686049.09968617,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_06 (
  "n_1622505600000" BIGINT  -- 1622505600000,
  "n_37253_82000000" DOUBLE  -- 37253.82000000,
  "n_37894_81000000" DOUBLE  -- 37894.81000000,
  "n_37100_00000000" DOUBLE  -- 37100.00000000,
  "n_37798_31000000" DOUBLE  -- 37798.31000000,
  "n_5234_07273500" DOUBLE  -- 5234.07273500,
  "n_1622509199999" BIGINT  -- 1622509199999,
  "n_196926607_50732204" DOUBLE  -- 196926607.50732204,
  "n_113551" BIGINT  -- 113551,
  "n_2496_94109700" DOUBLE  -- 2496.94109700,
  "n_93926954_66030555" DOUBLE  -- 93926954.66030555,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_07 (
  "n_1625097600000" BIGINT  -- 1625097600000,
  "n_35045_00000000" DOUBLE  -- 35045.00000000,
  "n_35057_57000000" DOUBLE  -- 35057.57000000,
  "n_34713_41000000" DOUBLE  -- 34713.41000000,
  "n_34727_83000000" DOUBLE  -- 34727.83000000,
  "n_2446_39319800" DOUBLE  -- 2446.39319800,
  "n_1625101199999" BIGINT  -- 1625101199999,
  "n_85212806_07288721" DOUBLE  -- 85212806.07288721,
  "n_48906" BIGINT  -- 48906,
  "n_1241_39963800" DOUBLE  -- 1241.39963800,
  "n_43238640_63420120" DOUBLE  -- 43238640.63420120,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_08 (
  "n_1627776000000" BIGINT  -- 1627776000000,
  "n_41461_84000000" DOUBLE  -- 41461.84000000,
  "n_41772_87000000" DOUBLE  -- 41772.87000000,
  "n_41120_00000000" DOUBLE  -- 41120.00000000,
  "n_41737_37000000" DOUBLE  -- 41737.37000000,
  "n_2544_49070400" DOUBLE  -- 2544.49070400,
  "n_1627779599999" BIGINT  -- 1627779599999,
  "n_105616154_72114946" DOUBLE  -- 105616154.72114946,
  "n_69767" BIGINT  -- 69767,
  "n_1205_69563900" DOUBLE  -- 1205.69563900,
  "n_50051959_90672302" DOUBLE  -- 50051959.90672302,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_09 (
  "n_1630454400000" BIGINT  -- 1630454400000,
  "n_47100_89000000" DOUBLE  -- 47100.89000000,
  "n_47321_42000000" DOUBLE  -- 47321.42000000,
  "n_46700_00000000" DOUBLE  -- 46700.00000000,
  "n_46754_74000000" DOUBLE  -- 46754.74000000,
  "n_2367_02148000" DOUBLE  -- 2367.02148000,
  "n_1630457999999" BIGINT  -- 1630457999999,
  "n_111144279_18794360" DOUBLE  -- 111144279.18794360,
  "n_59985" BIGINT  -- 59985,
  "n_1106_71447000" DOUBLE  -- 1106.71447000,
  "n_51977596_56473800" DOUBLE  -- 51977596.56473800,
  "n_0" BIGINT  -- 0
);