Query editor
1select *2from (3 select date_trunc('day', block_time) as day,4 blockchain,5 sum(amount_usd) as daily_volume6 from dex.trades7 where project = 'uniswap'8 and blockchain != 'ethereum'9 group by 1, 210)11order by daily_volume desc
select *
from (
select date_trunc('day', block_time) as day,
blockchain,
sum(amount_usd) as daily_volume
from dex.trades
where project = 'uniswap'
and blockchain != 'ethereum'
group by 1, 2
)
order by daily_volume desc