select

date_trunc('day', block_timestamp) as blocktime,

case when platform like '%uniswap%' then 'uniswap' else platform end as adjusted_platform,

sum(amount_usd) as volume

from ethereum.dex_swaps

where blocktime > getdate() - interval'60 days'

and amount_usd < 1e9

group by blocktime, adjusted_platform

select

*

from swap_volume

order by volume desc