steal as (

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'

),

kaito as (

select

block_timestamp,

tx_hash,

to_address,

amount,

amount_usd,

'Ethereum' as chain,

from ethereum.core.ez_token_transfers

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

and origin_function_signature = '0x69659658'

and contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'

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

and tx_hash not in (select tx_hash from steal)

select

count(tx_hash) as transactions,

count(distinct to_address) as user_address,

SUM(amount) as amount,

MAX(amount) as maximum_amount,

MIN(amount) as minimum_amount,

AVG(amount) as average_amount

from kaito