Query editor
with bebop_trades as(select tx_hash, amount_usd as volume_usdfrom bebop.tradeswhere block_time >= now() - interval '{{last_month}}' month and blockchain = 'base'), trade_weight as(select casewhen volume_usd < 100 then 'less than $100'when volume_usd >= 100 and volume_usd < 1000 then 'between $100 and $1k'when volume_usd >= 1000 and volume_usd < 10000 then 'between $1k and $10k'when volume_usd >= 10000 and volume_usd < 100000 then 'between $10k and $100k'when volume_usd >= 100000 and volume_usd < 1000000 then 'between $100k and $1m'when volume_usd >= 1000000 then 'more than $1m'end as vol_weightfrom bebop_trades)select vol_weight, vol_weight as g, count(vol_weight) as distribution, count(vol_weight) as radiusfrom trade_weightgroup by 1, 2having count(vol_weight) > 0order by 3 desc