Query editor
select date_trunc('day', block_time) as day, blockchain, sum(amount_usd) as volume_usdfrom bebop.tradeswhere block_time >= now() - interval '{{last_month}}' month and blockchain = 'base'group by 1, 2
Query editor
1select date_trunc('day', block_time) as day2, blockchain3, sum(amount_usd) as volume_usd4from bebop.trades5where block_time >= now() - interval '{{last_month}}' month and blockchain = 'base'6group by 1, 27