date(block_timestamp) as day,

count(distinct tx_hash) as swaps,

count(distinct origin_from_address) as swappers,

sum(

case when TOKEN_IN like lower('0x4c9EDD5852cd905f086C759E8383e09bff1E68B3')

then AMOUNT_IN

when TOKEN_out like lower('0x4c9EDD5852cd905f086C759E8383e09bff1E68B3')

then AMOUNT_out

end

) as swap_volume_eusd

from ethereum.defi.ez_dex_swaps

where (TOKEN_IN like lower('0x4c9EDD5852cd905f086C759E8383e09bff1E68B3')

or TOKEN_OUT like lower('0x4c9EDD5852cd905f086C759E8383e09bff1E68B3'))

and block_timestamp > '2025-01-01'

group by 1