date(block_timestamp) as day,

count(DISTINCT sender) as swappers,

count(DISTINCT tx_hash) as swaps,

sum(CASE when not amount_in_usd is null then amount_in_usd

else amount_out_usd end) as volume_usd

FROM ethereum.defi.ez_dex_swaps

WHERE (

token_in LIKE lower('0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3')

OR token_out LIKE lower('0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3')

GROUP BY 1