Query editor
1select project,2 sum(amount_usd) as usd_volume3 from dex.trades4 where block_time > now() - interval '7' day5 group by 1
select project,
sum(amount_usd) as usd_volume
from dex.trades
where block_time > now() - interval '7' day
group by 1