Query editor
with bebop_trades as(select taker as user, sum(count(tx_hash)) over(partition by taker) as trx_num, min(block_date) as first_trade, max(block_date) as last_trade, avg(amount_usd) as average_vol_usd, sum(amount_usd) as total_vol_usd, count(distinct block_date) as active_days, count(distinct date_trunc('week', block_date)) as active_weeks, count(distinct block_month) as active_monthsfrom bebop.tradeswhere blockchain = 'base'group by 1having sum(amount_usd) > 0), ens as(select distinct address, first_value(name) over(partition by address order by updated_at) as ens_namefrom labels.ens), bot_trader as(select addressfrom labels.addresseswhere blockchain = 'ethereum'and (name = 'Daily Trader' or name like '%BebopSettlement%' or name like '%JamSettlement%'))select row_number() over(order by total_vol_usd desc) as rank, user, ens_name, get_href('https://debank.com/profile/' || cast(user as varchar), '🔗') as debank, trx_num, first_trade, last_trade, active_days, active_weeks, active_months, average_vol_usd, total_vol_usdfrom bebop_tradesleft join ens on user = addresswhere user not in (select address from bot_trader)order by 1