CASE WHEN platform ILIKE '%aerodrome%' THEN 'aerodrome'

WHEN platform ILIKE '%uniswap%' THEN 'uniswap'

ELSE platform END AS d_platform

, SUM((amount_in_usd+amount_out_usd)/2) AS volume

, Count(DISTINCT tx_hash) AS Txs

, COUNT(DISTINCT origin_from_address) AS users

FROM base.defi.ez_dex_swaps

WHERE 1=1

AND (token_in = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')

OR token_out = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE'))

AND amount_in_usd > 0

AND amount_out_usd > 0

GROUP BY 1

ORDER BY 2 DESC