distinct TO_ADDRESS as claimant_wallet,

min(Block_timestamp::date) as claimed_date,

sum(amount) as Claimed_Amount

from blast.core.ez_token_transfers

where contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and FROM_ADDRESS = lower('0xf7be503166828fe8565c520d66645ac6a06bbdd7')

and ORIGIN_FUNCTION_SIGNATURE = '0xcd9829d9'

and amount > 0

and TO_ADDRESS != '0xa4bd562c37c19c569c5b4418d12d35fa9964931f'

group by 1

order by 3 desc

),

cext as (

select

distinct address

FROM blast.core.ez_token_transfers

join blast.core.dim_labels on TO_ADDRESS = address

WHERE contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and LABEL_TYPE = 'cex'

and LABEL_SUBTYPE = 'hot_wallet'

),

dext as (

select

distinct TX_HASH

FROM blast.core.ez_token_transfers

join blast.core.dim_labels on TO_ADDRESS = address

WHERE contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and LABEL_TYPE = 'dex'

and LABEL_SUBTYPE = 'swap_contract'

),