Flippppppa2023-03-17 05:53 PM copy
    Updated 2023-03-17
    -- forked from cb6f3643-6589-4899-8b1f-597370030955

    SELECT
    Allocation AS "Allocated ARB Amount"
    , COUNT(DISTINCT(addresses)) AS "Number of Addresses"
    FROM (
    SELECT
    CONCAT('0x', SUBSTR(TOPICS[1], 27, length(TOPICS[1]) - 26)) AS addresses
    , CASE DATA
    WHEN '0x000000000000000000000000000000000000000000000021e19e0c9bab240000' THEN '625'
    WHEN '0x00000000000000000000000000000000000000000000002f6f10780d22cc0000' THEN '875'
    WHEN '0x00000000000000000000000000000000000000000000022ba753352c29e80000' THEN '10250'
    WHEN '0x00000000000000000000000000000000000000000000003cfc82e37e9a740000' THEN '1125'
    WHEN '0x0000000000000000000000000000000000000000000000bdbc41e0348b300000' THEN '3500'
    WHEN '0x00000000000000000000000000000000000000000000011c9a62d04ed0c80000' THEN '5250'
    WHEN '0x000000000000000000000000000000000000000000000043c33c193756480000' THEN '1250'
    WHEN '0x000000000000000000000000000000000000000000000079f905c6fd34e80000' THEN '2250'
    WHEN '0x00000000000000000000000000000000000000000000010f0cf064dd59200000' THEN '5000'
    WHEN '0x00000000000000000000000000000000000000000000009513ea9de024380000' THEN '2750'
    WHEN '0x00000000000000000000000000000000000000000000005ede20f01a45980000' THEN '1750'
    WHEN '0x00000000000000000000000000000000000000000000017b7883c06916600000' THEN '7000'
    WHEN '0x0000000000000000000000000000000000000000000000581767ba6189c40000' THEN '1625'
    WHEN '0x0000000000000000000000000000000000000000000000a2a15d09519be00000' THEN '3000'
    WHEN '0x00000000000000000000000000000000000000000000005150ae84a8cdf00000' THEN '1500'
    WHEN '0x00000000000000000000000000000000000000000000016deb1154f79eb80000' THEN '6750'
    WHEN '0x000000000000000000000000000000000000000000000073324c914479140000' THEN '2125'
    WHEN '0x000000000000000000000000000000000000000000000065a4da25d3016c0000' THEN '1875'
    WHEN '0x0000000000000000000000000000000000000000000000e664992288f2280000' THEN '4250'
    WHEN '0x0000000000000000000000000000000000000000000000cb49b44ba602d80000' THEN '3750'
    WHEN '0x00000000000000000000000000000000000000000000018905f62bda8e080000' THEN '7250'
    WHEN '0x00000000000000000000000000000000000000000000006c6b935b8bbd400000' THEN '2000'
    WHEN '0x000000000000000000000000000000000000000000000152d02c7e14af680000' THEN '6250'
    WHEN '0x0000000000000000000000000000000000000000000000878678326eac900000' THEN '2500'
    WHEN '0x00000000000000000000000000000000000000000000012a27d53bc048700000' THEN '5500'
    WHEN '0x0000000000000000000000000000000000000000000000b02ecf74c313880000' THEN '3250'
    WHEN '0x0000000000000000000000000000000000000000000000b6f588aa7bcf5c0000' THEN '3375'
    Run a query to Download Data