select * , ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY event_index) AS row_num

from ethereum.core.ez_token_transfers

where origin_from_address = '0xfde0d1575ed8e06fbf36256bcdfa1f359281455a'

and origin_to_address = '0x80bf7db69556d9521c03461978b8fc731dbbd4e4'

and origin_function_signature = '0x9846cd9e'

and contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'

and block_timestamp::date >= '2025-04-10'

qualify row_num = 1

select

count(tx_hash) as transactions,

sum(amount) as amount,

sum(amount_usd) as amount_usd

from transactions