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'

),

base as (

select * , 'Cache or Campaign' as label

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'

),

ethereum as(

select * , 'Cache or Campaign' as label

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'

and tx_hash not in (select tx_hash from steal)

),

kaito as (

select

block_timestamp,

tx_hash,

to_address as user,

amount,

amount_usd,

'KAITO ✨' as label