Bitcoin Historical Prices Binance API

CREATE TABLE btcusdt_1h_2021_10 (
  "n_1633046400000" BIGINT  -- 1633046400000,
  "n_43820_01000000" DOUBLE  -- 43820.01000000,
  "n_44059_00000000" DOUBLE  -- 44059.00000000,
  "n_43661_63000000" DOUBLE  -- 43661.63000000,
  "n_43694_48000000" DOUBLE  -- 43694.48000000,
  "n_2001_56071000" DOUBLE  -- 2001.56071000,
  "n_1633049999999" BIGINT  -- 1633049999999,
  "n_87792530_45453530" DOUBLE  -- 87792530.45453530,
  "n_46349" BIGINT  -- 46349,
  "n_896_39059000" DOUBLE  -- 896.39059000,
  "n_39324120_95889630" DOUBLE  -- 39324120.95889630,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_11 (
  "n_1635724800000" BIGINT  -- 1635724800000,
  "n_61299_81000000" DOUBLE  -- 61299.81000000,
  "n_61660_27000000" DOUBLE  -- 61660.27000000,
  "n_61115_33000000" DOUBLE  -- 61115.33000000,
  "n_61560_49000000" DOUBLE  -- 61560.49000000,
  "n_1423_33658000" DOUBLE  -- 1423.33658000,
  "n_1635728399999" BIGINT  -- 1635728399999,
  "n_87460568_53074420" DOUBLE  -- 87460568.53074420,
  "n_52006" BIGINT  -- 52006,
  "n_698_21070000" DOUBLE  -- 698.21070000,
  "n_42899789_92090920" DOUBLE  -- 42899789.92090920,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2021_12 (
  "n_1638316800000" BIGINT  -- 1638316800000,
  "n_56950_56000000" DOUBLE  -- 56950.56000000,
  "n_57686_12000000" DOUBLE  -- 57686.12000000,
  "n_56630_00000000" DOUBLE  -- 56630.00000000,
  "n_57577_07000000" DOUBLE  -- 57577.07000000,
  "n_1693_73069000" DOUBLE  -- 1693.73069000,
  "n_1638320399999" BIGINT  -- 1638320399999,
  "n_97020123_36229970" DOUBLE  -- 97020123.36229970,
  "n_55827" BIGINT  -- 55827,
  "n_888_92002000" DOUBLE  -- 888.92002000,
  "n_50916209_61763840" DOUBLE  -- 50916209.61763840,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_01 (
  "n_1640995200000" BIGINT  -- 1640995200000,
  "n_46216_93000000" DOUBLE  -- 46216.93000000,
  "n_46731_39000000" DOUBLE  -- 46731.39000000,
  "n_46208_37000000" DOUBLE  -- 46208.37000000,
  "n_46656_13000000" DOUBLE  -- 46656.13000000,
  "n_1503_33095000" DOUBLE  -- 1503.33095000,
  "n_1640998799999" BIGINT  -- 1640998799999,
  "n_69879986_39049930" DOUBLE  -- 69879986.39049930,
  "n_38608" BIGINT  -- 38608,
  "n_806_06536000" DOUBLE  -- 806.06536000,
  "n_37462156_91764400" DOUBLE  -- 37462156.91764400,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_02 (
  "n_1643673600000" BIGINT  -- 1643673600000,
  "n_38466_90000000" DOUBLE  -- 38466.90000000,
  "n_38627_35000000" DOUBLE  -- 38627.35000000,
  "n_38276_43000000" DOUBLE  -- 38276.43000000,
  "n_38342_36000000" DOUBLE  -- 38342.36000000,
  "n_1058_42599000" DOUBLE  -- 1058.42599000,
  "n_1643677199999" BIGINT  -- 1643677199999,
  "n_40649138_24899430" DOUBLE  -- 40649138.24899430,
  "n_29658" BIGINT  -- 29658,
  "n_507_18059000" DOUBLE  -- 507.18059000,
  "n_19479794_62317360" DOUBLE  -- 19479794.62317360,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_03 (
  "n_1646092800000" BIGINT  -- 1646092800000,
  "n_43160_00000000" DOUBLE  -- 43160.00000000,
  "n_43750_00000000" DOUBLE  -- 43750.00000000,
  "n_43155_68000000" DOUBLE  -- 43155.68000000,
  "n_43560_00000000" DOUBLE  -- 43560.00000000,
  "n_3476_11347000" DOUBLE  -- 3476.11347000,
  "n_1646096399999" BIGINT  -- 1646096399999,
  "n_150929685_99337100" DOUBLE  -- 150929685.99337100,
  "n_92781" BIGINT  -- 92781,
  "n_1884_95010000" DOUBLE  -- 1884.95010000,
  "n_81846638_77186550" DOUBLE  -- 81846638.77186550,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_04 (
  "n_1648771200000" BIGINT  -- 1648771200000,
  "n_45510_35000000" DOUBLE  -- 45510.35000000,
  "n_45644_86000000" DOUBLE  -- 45644.86000000,
  "n_45351_73000000" DOUBLE  -- 45351.73000000,
  "n_45541_50000000" DOUBLE  -- 45541.50000000,
  "n_1838_20071000" DOUBLE  -- 1838.20071000,
  "n_1648774799999" BIGINT  -- 1648774799999,
  "n_83712318_65105210" DOUBLE  -- 83712318.65105210,
  "n_51792" BIGINT  -- 51792,
  "n_940_42832000" DOUBLE  -- 940.42832000,
  "n_42827268_69736760" DOUBLE  -- 42827268.69736760,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_05 (
  "n_1651363200000" BIGINT  -- 1651363200000,
  "n_37630_80000000" DOUBLE  -- 37630.80000000,
  "n_37806_79000000" DOUBLE  -- 37806.79000000,
  "n_37500_00000000" DOUBLE  -- 37500.00000000,
  "n_37680_67000000" DOUBLE  -- 37680.67000000,
  "n_2313_83572000" DOUBLE  -- 2313.83572000,
  "n_1651366799999" BIGINT  -- 1651366799999,
  "n_87126400_19490190" DOUBLE  -- 87126400.19490190,
  "n_55934" BIGINT  -- 55934,
  "n_1052_75000000" DOUBLE  -- 1052.75000000,
  "n_39653787_48505660" DOUBLE  -- 39653787.48505660,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_06 (
  "n_1654041600000" BIGINT  -- 1654041600000,
  "n_31801_05000000" DOUBLE  -- 31801.05000000,
  "n_31982_97000000" DOUBLE  -- 31982.97000000,
  "n_31688_01000000" DOUBLE  -- 31688.01000000,
  "n_31936_54000000" DOUBLE  -- 31936.54000000,
  "n_2237_33599000" DOUBLE  -- 2237.33599000,
  "n_1654045199999" BIGINT  -- 1654045199999,
  "n_71243083_26194620" DOUBLE  -- 71243083.26194620,
  "n_42824" BIGINT  -- 42824,
  "n_1126_48151000" DOUBLE  -- 1126.48151000,
  "n_35871982_40806280" DOUBLE  -- 35871982.40806280,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_07 (
  "n_1656633600000" BIGINT  -- 1656633600000,
  "n_19942_21000000" DOUBLE  -- 19942.21000000,
  "n_20918_35000000" DOUBLE  -- 20918.35000000,
  "n_19658_97000000" DOUBLE  -- 19658.97000000,
  "n_20295_08000000" DOUBLE  -- 20295.08000000,
  "n_15102_27957000" DOUBLE  -- 15102.27957000,
  "n_1656637199999" BIGINT  -- 1656637199999,
  "n_306127968_67862280" DOUBLE  -- 306127968.67862280,
  "n_183055" BIGINT  -- 183055,
  "n_7869_03338000" DOUBLE  -- 7869.03338000,
  "n_159583485_90658690" DOUBLE  -- 159583485.90658690,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_08 (
  "n_1659312000000" BIGINT  -- 1659312000000,
  "n_23296_36000000" DOUBLE  -- 23296.36000000,
  "n_23394_97000000" DOUBLE  -- 23394.97000000,
  "n_23257_37000000" DOUBLE  -- 23257.37000000,
  "n_23374_96000000" DOUBLE  -- 23374.96000000,
  "n_5110_59195000" DOUBLE  -- 5110.59195000,
  "n_1659315599999" BIGINT  -- 1659315599999,
  "n_119208972_79285610" DOUBLE  -- 119208972.79285610,
  "n_184426" BIGINT  -- 184426,
  "n_2652_53834000" DOUBLE  -- 2652.53834000,
  "n_61875576_42013090" DOUBLE  -- 61875576.42013090,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_09 (
  "n_1661990400000" BIGINT  -- 1661990400000,
  "n_20048_44000000" DOUBLE  -- 20048.44000000,
  "n_20138_15000000" DOUBLE  -- 20138.15000000,
  "n_19917_01000000" DOUBLE  -- 19917.01000000,
  "n_20064_43000000" DOUBLE  -- 20064.43000000,
  "n_11108_70225000" DOUBLE  -- 11108.70225000,
  "n_1661993999999" BIGINT  -- 1661993999999,
  "n_222708634_02234470" DOUBLE  -- 222708634.02234470,
  "n_279177" BIGINT  -- 279177,
  "n_5395_01867000" DOUBLE  -- 5395.01867000,
  "n_108163009_75153420" DOUBLE  -- 108163009.75153420,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_10 (
  "n_1664582400000" BIGINT  -- 1664582400000,
  "n_19422_61000000" DOUBLE  -- 19422.61000000,
  "n_19484_00000000" DOUBLE  -- 19484.00000000,
  "n_19351_02000000" DOUBLE  -- 19351.02000000,
  "n_19402_88000000" DOUBLE  -- 19402.88000000,
  "n_8651_64878000" DOUBLE  -- 8651.64878000,
  "n_1664585999999" BIGINT  -- 1664585999999,
  "n_167994055_19173440" DOUBLE  -- 167994055.19173440,
  "n_128640" BIGINT  -- 128640,
  "n_4251_53758000" DOUBLE  -- 4251.53758000,
  "n_82562815_68299460" DOUBLE  -- 82562815.68299460,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_11 (
  "n_1667260800000" BIGINT  -- 1667260800000,
  "n_20490_74000000" DOUBLE  -- 20490.74000000,
  "n_20505_62000000" DOUBLE  -- 20505.62000000,
  "n_20440_64000000" DOUBLE  -- 20440.64000000,
  "n_20456_57000000" DOUBLE  -- 20456.57000000,
  "n_10863_93121000" DOUBLE  -- 10863.93121000,
  "n_1667264399999" BIGINT  -- 1667264399999,
  "n_222398755_71269850" DOUBLE  -- 222398755.71269850,
  "n_250805" BIGINT  -- 250805,
  "n_5327_63709000" DOUBLE  -- 5327.63709000,
  "n_109068175_07293900" DOUBLE  -- 109068175.07293900,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2022_12 (
  "n_1669852800000" BIGINT  -- 1669852800000,
  "n_17165_53000000" DOUBLE  -- 17165.53000000,
  "n_17236_29000000" DOUBLE  -- 17236.29000000,
  "n_17122_65000000" DOUBLE  -- 17122.65000000,
  "n_17161_55000000" DOUBLE  -- 17161.55000000,
  "n_14452_68614000" DOUBLE  -- 14452.68614000,
  "n_1669856399999" BIGINT  -- 1669856399999,
  "n_248290110_60733690" DOUBLE  -- 248290110.60733690,
  "n_343677" BIGINT  -- 343677,
  "n_6911_20473000" DOUBLE  -- 6911.20473000,
  "n_118736251_61600120" DOUBLE  -- 118736251.61600120,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2023_01 (
  "n_1672531200000" BIGINT  -- 1672531200000,
  "n_16541_77000000" DOUBLE  -- 16541.77000000,
  "n_16545_70000000" DOUBLE  -- 16545.70000000,
  "n_16508_39000000" DOUBLE  -- 16508.39000000,
  "n_16529_67000000" DOUBLE  -- 16529.67000000,
  "n_4364_83570000" DOUBLE  -- 4364.83570000,
  "n_1672534799999" BIGINT  -- 1672534799999,
  "n_72146293_58672290" DOUBLE  -- 72146293.58672290,
  "n_149854" BIGINT  -- 149854,
  "n_2179_94772000" DOUBLE  -- 2179.94772000,
  "n_36032352_87035720" DOUBLE  -- 36032352.87035720,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2023_02 (
  "n_1675209600000" BIGINT  -- 1675209600000,
  "n_23125_13000000" DOUBLE  -- 23125.13000000,
  "n_23168_90000000" DOUBLE  -- 23168.90000000,
  "n_22997_10000000" DOUBLE  -- 22997.10000000,
  "n_23085_73000000" DOUBLE  -- 23085.73000000,
  "n_12121_64019000" DOUBLE  -- 12121.64019000,
  "n_1675213199999" BIGINT  -- 1675213199999,
  "n_279785863_47569260" DOUBLE  -- 279785863.47569260,
  "n_310758" BIGINT  -- 310758,
  "n_5920_42967000" DOUBLE  -- 5920.42967000,
  "n_136660177_26293370" DOUBLE  -- 136660177.26293370,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2023_03 (
  "n_1677628800000" BIGINT  -- 1677628800000,
  "n_23141_57000000" DOUBLE  -- 23141.57000000,
  "n_23219_99000000" DOUBLE  -- 23219.99000000,
  "n_23020_03000000" DOUBLE  -- 23020.03000000,
  "n_23101_00000000" DOUBLE  -- 23101.00000000,
  "n_12736_94918000" DOUBLE  -- 12736.94918000,
  "n_1677632399999" BIGINT  -- 1677632399999,
  "n_294608802_25086680" DOUBLE  -- 294608802.25086680,
  "n_430193" BIGINT  -- 430193,
  "n_6319_19996000" DOUBLE  -- 6319.19996000,
  "n_146161637_97230100" DOUBLE  -- 146161637.97230100,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2023_04 (
  "n_1680307200000" BIGINT  -- 1680307200000,
  "n_28465_36000000" DOUBLE  -- 28465.36000000,
  "n_28547_20000000" DOUBLE  -- 28547.20000000,
  "n_28408_57000000" DOUBLE  -- 28408.57000000,
  "n_28438_27000000" DOUBLE  -- 28438.27000000,
  "n_1524_81719000" DOUBLE  -- 1524.81719000,
  "n_1680310799999" BIGINT  -- 1680310799999,
  "n_43415784_73435520" DOUBLE  -- 43415784.73435520,
  "n_46983" BIGINT  -- 46983,
  "n_738_40413000" DOUBLE  -- 738.40413000,
  "n_21027000_66934780" DOUBLE  -- 21027000.66934780,
  "n_0" BIGINT  -- 0
);

CREATE TABLE btcusdt_1h_2023_05 (
  "n_1682899200000" BIGINT  -- 1682899200000,
  "n_29233_20000000" DOUBLE  -- 29233.20000000,
  "n_29337_34000000" DOUBLE  -- 29337.34000000,
  "n_29215_93000000" DOUBLE  -- 29215.93000000,
  "n_29315_57000000" DOUBLE  -- 29315.57000000,
  "n_1884_84043000" DOUBLE  -- 1884.84043000,
  "n_1682902799999" BIGINT  -- 1682902799999,
  "n_55200888_19800800" DOUBLE  -- 55200888.19800800,
  "n_43324" BIGINT  -- 43324,
  "n_898_64952000" DOUBLE  -- 898.64952000,
  "n_26318179_46702700" DOUBLE  -- 26318179.46702700,
  "n_0" BIGINT  -- 0
);