Query editor
1select block_date as day2 , trade_type3 , count(tx_hash) as trade_type_num4from bebop.trades5where block_time >= now() - interval '{{last_month}}' month and blockchain = 'base'6group by 1, 2
select block_date as day
, trade_type
, count(tx_hash) as trade_type_num
from bebop.trades
where block_time >= now() - interval '{{last_month}}' month and blockchain = 'base'
group by 1, 2