Query editor
1select2 block_date3 , blockchain4 , COUNT(*) as trades_count5 , SUM(amount_usd) as volume_usd6from dex.trades7where block_date >= NOW() - INTERVAL '7' day8group by9 110 , 211order by12 1 desc
select
block_date
, blockchain
, COUNT(*) as trades_count
, SUM(amount_usd) as volume_usd
from dex.trades
where block_date >= NOW() - INTERVAL '7' day
group by
1
, 2
order by
1 desc