claims as (

select *, 1 as row_num

from ethereum.core.ez_token_transfers

where contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'

and from_address = '0x77a6149395ca96b13df5bbd634965bcfbeedb1c9'

and origin_function_signature = '0xcfd2afa9'

and block_timestamp >= '2025-04-10 12:00:00.000'

union all

select * , 1 as row_num

from base.core.ez_token_transfers

contract_address = '0x30c7235866872213f68cb1f08c37cb9eccb93452'

and from_address = '0x7c8aa3dd42fc0c9646552c638af532eb56ccbea8'

and origin_function_signature = '0xcfd2afa9'

and block_timestamp >= '2025-04-10 12:00:00.000'

),

kaito as (

select block_timestamp, tx_hash, to_address as user, amount, amount_usd, 'kaito' as label, 1 as row_num,

from ethereum.core.ez_token_transfers

where

from_address in ('0x1a8b3bdc38566df28b0b4e65dc28af2069eb0645','0x762d1247aa6322e3acd1b57c976ae04c3f142c5d')

and contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'

and origin_function_signature = '0x69659658'

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

union all

select

block_timestamp, tx_hash, to_address as user, amount, amount_usd, 'kaito' as label, 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