marquHelium - [devices] hourly and cumul mints
    Updated 2024-04-10
    with

    compressed_names as (

    select * from (
    values
    ('9MaWh59en5ibhtKnF66ti57bEy8TAMjqrP2fYg9LqPuL', 'Migrated Helium Hotspot'),
    ('Ewoaj3hWwSaWuvvsLsWDRZYQk9ZiALPMwYk3XRxJC4eP', 'RisingHF'),
    ('H4rCPV8EPg7guFYaB8g4A5SeADBbtAwmDqGfqEbBTwuL', 'KS Technologies'),
    ('6q1DeLeQGspridckcd4AjGFy2yTT1pJoq14Vfr15sbxX', 'TMG'),
    ('BjRuZ4ZYEv6SEsyPUWKAAw11ChgddMtwcZWcF6emDDbf', 'LongAP'),
    ('HXxZRpcwf5oHHcPQMLZ7KWPJJ3WZaNughAPqWv1LX3UR', 'Pisces Miner'),
    ('3hCnRKCDDwjrjT9xSKnUf6wQW1k5CwiHwVs57Syh4LPc', 'Bobcat'),
    ('CMu5QDPXpjyZtGbJcwqFS7PMV5xJCPGT8yqv2BerNXED', 'EDA-IoT'),
    ('2GFc7nv8fzkNrbaG4XHzd7aDEmSW768m9gyExwDtguik', 'Dusun'),
    ('A9Xuhh9fYpXRKxLxw6Dn8HGbNxNcw6BwhBQXdAbGWeXp', 'Aitek Inc'),
    ('9q2Hm4VhD3HZoF9PvsTbZpaJwoPT7Dfe5F8VzJWavKNL', 'uG Miner'),
    ('DXDoz4U3DJWKiY59WCesNsHZ1wEATshcTUozFZ2Jqixg', 'SyncroB.it'),
    ('BB1W9Fidmy1rJTGAch3ywCPFUsybsDJVfKZL6KMfc7vQ', 'Deeper'),
    ('wKWLvC4h14JZR5QFwbPhDZdfX85dt3cpyyoK4AirUc1', 'OPTION'),
    ('FLMKUPscdsiyqpi4fuUKtqs7JWaF21mqYtizxsFRayB7', 'hummingbird'),
    ('DPQoDabxRpSkEghEzABHgGnrsE28jsLJPPndnMJPcqub', 'Helium Inc'),
    ('Ds6X17RFTwg9DjPZgcg1FTCsrBpH42tqHpjrAzrUq3mq', 'Browan/MerryIoT'),
    ('6A3cDb6VNr2y4eThxsD6aidVV4pz3Uj3yehRbGN6btdB', 'Kerlink'),
    ('8ckXtbcXATAwk5kz4aMBaxWreyHZ26pHtLkNhzE9NPMz', 'CalChip Connect'),
    ('nd4AMJq1HXtyEYiMfNxTJx1a4rWwdfdSF3qsvyK3ap8', 'Atom'),
    ('6hk6sUH2kHxoUyVEkhvCp4jp9f3DWvxNfHVUFbRgtn67', 'Polyhex'),
    ('Do2E3zMc7NPt4uoXkS4d6wZGXrDoXnWR5t7MCB1w3Djh', 'Midas'),
    ('8SEkbjAhseYnduVCnL9h6fshNcYzPSFFBebkynYyLSXQ', 'Dragino'),
    ('8dWemVvLibkmHgEs3s2Y3jkeMitUKopubd6Tk7yX4zMN', 'SONoC'),
    ('BWVSPDVRk2s5Kkc6nnGw4nQDTztdfacrz5WLBa1NwU9W', 'ClodPi'),
    ('7VZFJp5smZBdwysc42xcKPvgEDcZsV4J3AZ3Qyp66JV2', 'DeWi Foundation'),
    ('8ajV5vxmLSq7gj43DyAxPQ1TUSHZjHGmhASPg7z32rtB', 'Mimiq'),
    ('ACe5VywkVxwcx32eUL5cwKjZ58xAbUhWYo6tx4MpfKsV', 'SenseCAP'),
    ('CXYocjqze1ZCXS46jPB1hUWYm4v4BP9WTrVR8tFeMmRk', 'Pycom'),
    ('HuzUUyz4xgCLgEGPmZa3cwsLPzEXfT4CwPqBDGHX5C9m', 'Milesight'),
    QueryRunArchived: QueryRun has been archived