Query editor
-- Solana: top 5 pairs by 7d volume — BisonFi, GoonFi, Manifest, SolFiwith base as (select project,coalesce(token_bought_symbol, substr(token_bought_mint_address,1,5) || '…') as sym_b,coalesce(token_sold_symbol, substr(token_sold_mint_address,1,5) || '…') as sym_s,amount_usdfrom dex_solana.tradeswhere block_time > now() - interval '7' dayand amount_usd > 0 and amount_usd < 1e9and project in ('bisonfi','goonfi','manifest','solfi')),dex_tot as (select project, sum(amount_usd) as dex_vol_7dfrom base group by 1),pairs as (select b.project,least(b.sym_b, b.sym_s) || '-' || greatest(b.sym_b, b.sym_s) as pair,sum(b.amount_usd) as pair_vol_7d,count(*) as fillsfrom base bgroup by 1, 2),ranked as (select p.*, t.dex_vol_7d,row_number() over (partition by p.project order by p.pair_vol_7d desc) as pair_rankfrom pairs pjoin dex_tot t on t.project = p.project)select project as dex,pair_rank,pair,round(pair_vol_7d / 1e6, 2) as pair_vol_7d_m_usd,round(100.0 * pair_vol_7d / dex_vol_7d, 2) as pct_of_dex,fillsfrom rankedwhere pair_rank <= 5order by dex, pair_rank