SELECT '0x111111111117dc0aa78b770fa6a738034120c302' AS c_contract_address

, 'claim' AS c_origin_function_name

), airdrop_recipients AS (

SELECT to_address AS address

, MIN(block_timestamp) AS rec_time

, SUM(amount) AS airdrop_amt

FROM ethereum.udm_events u

JOIN constants c ON c.c_contract_address = u.contract_address

AND c.c_origin_function_name = u.origin_function_name

WHERE from_address IN ( '0xe295ad71242373c37c5fda7b57f26f9ea1088afe', '0x4ee7c0f5480eb1edd8902a5e8b991ed52992d5f5' )

AND block_timestamp < CURRENT_DATE - 90

GROUP BY 1

), transfers_to_0 AS (

SELECT to_address AS address

, SUM(amount) AS transfer_to_amt

FROM ethereum.udm_events u

JOIN airdrop_recipients r ON r.address = u.to_address

AND u.block_timestamp > r.rec_time

JOIN constants c ON c.c_contract_address = u.contract_address

WHERE from_label IS NULL

GROUP BY 1

), transfers_from_0 AS (

SELECT from_address AS address

, SUM(amount) AS transfer_from_amt

FROM ethereum.udm_events u

JOIN constants c ON c.c_contract_address = u.contract_address

JOIN airdrop_recipients r ON r.address = u.from_address

AND u.block_timestamp > r.rec_time

WHERE to_label IS NULL

GROUP BY 1

), cex_transfers_to_0 AS (

SELECT to_address AS address

, SUM(amount) AS cex_transfer_to_amt

FROM ethereum.udm_events u

JOIN constants c ON c.c_contract_address = u.contract_address