date_trunc('week', block_timestamp) as week,

CASE when from_address LIKE '0x0000000000000000000000000000000000000000' then 'Mantle -> Ethereum'

else 'Ethereum -> Mantle' end as bridge_direction,

sum(amount) as volume,

count(DISTINCT

CASE when from_address LIKE '0x0000000000000000000000000000000000000000' then to_address

else from_address end

) as users,

count(DISTINCT tx_hash) as transactions

FROM ethereum.core.ez_token_transfers

WHERE contract_address LIKE lower('0x96F6eF951840721AdBF46Ac996b59E0235CB985C')

AND (from_address LIKE '0x0000000000000000000000000000000000000000'

or to_address LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1,2