all_arb_airdrops as (

select

ethereum.public.udf_hex_to_int (DATA) / pow(10, 18) AS AMOUNT,

CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS AIRDROP_WALLET_RECIPIENT,

BLOCK_NUMBER,

BLOCK_TIMESTAMP,

TX_HASH

FROM

arbitrum.core.fact_event_logs

WHERE

ORIGIN_TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'

AND ORIGIN_FUNCTION_SIGNATURE = '0xae373c1b'

AND BLOCK_NUMBER >= 70506697

AND TX_STATUS = 'SUCCESS'

)

SELECT

AMOUNT,

CASE when amount < 1500 then 'Below 1,500 $ARB Airdrop'

when amount < 3000 then '1,500 - 3,000 $ARB Airdrop'

when amount < 5000 then '3,000 - 5,000 $ARB Airdrop'

when amount < 8000 then '5,000 - 8,000 $ARB Airdrop'

else '8,000 and above $ARB Airdrop' end Airdrop_amount,

COUNT(AMOUNT) AS WALLETS,

SUM(AMOUNT) AS Airdrop_volume

FROM all_arb_airdrops

GROUP BY 1,2