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

COUNT(DISTINCT AIRDROP_WALLET_RECIPIENT) AS WALLETS,

SUM(AMOUNT) AS Airdrop_volume,

avg(AMOUNT) as Avg_Airdrop,

median(AMOUNT) as median_airdrop

FROM all_arb_airdrops