Query editor
1select 2date_trunc('month',block_date) as month3,blockchain4,project5,sum(amount_usd) as volume6from dex_aggregator.trades 7group by date_trunc('month',block_date),blockchain,project8
select
date_trunc('month',block_date) as month
,blockchain
,project
,sum(amount_usd) as volume
from dex_aggregator.trades
group by date_trunc('month',block_date),blockchain,project