with swap_volume as (
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