Query editor
select blockchain,date_trunc('week', block_time),sum(amount_usd) as usd_volumefrom dex.tradeswhere block_time >= date('2023-01-01')group by 1,2
Query editor
1select blockchain,2date_trunc('week', block_time),3sum(amount_usd) as usd_volume4from dex.trades5where block_time >= date('2023-01-01')6group by 1,2