WITH base_transfers AS (

SELECT

decoded_log:from::string as from_address,

decoded_log:to::string as to_address,

CAST(decoded_log:value::string AS DECIMAL) / 1e18 as amount,

block_timestamp,

tx_hash

FROM base.core.ez_decoded_event_logs

WHERE contract_address = LOWER('0x3eE5e23eEE121094f1cFc0Ccc79d6C809Ebd22e5')

AND event_name = 'Transfer'

AND block_timestamp >= CURRENT_DATE - 30

),

user_activity AS (

SELECT

CASE

WHEN from_address = LOWER('0x0fac819628a7f612abac1cad939768058cc0170c') THEN to_address

WHEN to_address = LOWER('0x0fac819628a7f612abac1cad939768058cc0170c') THEN from_address

END as user_address,

SUM(CASE

WHEN from_address = LOWER('0x0fac819628a7f612abac1cad939768058cc0170c')

THEN amount

ELSE 0

END) as total_received,

SUM(CASE

WHEN to_address = LOWER('0x0fac819628a7f612abac1cad939768058cc0170c')

THEN amount

ELSE 0

END) as total_returned

FROM base_transfers

GROUP BY 1

HAVING total_received > 0 -- Include all users who received anything

),

dex_activity AS (

SELECT