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

project_name,

count(DISTINCT from_address) as users,

count(DISTINCT tx_hash) as interactions

FROM arbitrum.core.fact_transactions

LEFT outer JOIN arbitrum.core.dim_labels

on address = to_address

WHERE from_address IN (SELECT AIRDROP_WALLET_RECIPIENT FROM all_arb_airdrops)

AND block_timestamp > '2023-03-21'

AND not project_name LIKE 'arbitrum foundation'

GROUP BY 1

HAVING not project_name is NULL

ORDER BY 2 DESC

LIMIT 10