Query editor
1select token_pair2 , sum(amount_usd) as vol_usd3from bebop.trades4where block_time >= now() - interval '{{last_month}}' month5 and token_pair is not null and blockchain = 'base'6group by 17order by 2 desc8limit 100
select token_pair
, sum(amount_usd) as vol_usd
from bebop.trades
where block_time >= now() - interval '{{last_month}}' month
and token_pair is not null and blockchain = 'base'
group by 1
order by 2 desc
limit 100