Query editor
with bot_trader as(select addressfrom labels.addresseswhere blockchain = 'ethereum'and (name = 'Daily Trader' or name like '%BebopSettlement%' or name like '%JamSettlement%'))select date_trunc('day', t.block_time) as day, t.blockchain, casewhen t.taker in (select address from bot_trader) then 'bot'else 'non-bot'end as trader_type, sum(t.amount_usd) as volume_usdfrom bebop.trades twhere t.block_time >= now() - interval '{{last_month}}' monthand t.blockchain = 'base'group by 1, 2, 3order by 1, 3