Query editor
-- LCMM BUBBLES Top v3-- Every coin the trenches ever produced, ranked by today's volume —-- wherever it now trades. Membership is the pump vanity suffix, which-- a mint carries permanently: born on the curve, still counted after-- it outgrows the curve. Crowd and pipe columns as before.with legs as (select token_bought_mint_address as mint, trader_id, amount_usd, 'b' as sidefrom dex_solana.tradeswhere block_time >= now() - interval '1' dayand token_bought_mint_address like '%pump'union allselect token_sold_mint_address as mint, trader_id, amount_usd, 's' as sidefrom dex_solana.tradeswhere block_time >= now() - interval '1' dayand token_sold_mint_address like '%pump')select mint,sum(amount_usd) as vol_usd,count(distinct trader_id) as traders,count(distinct case when side = 's' then trader_id end) as sellersfrom legsgroup by 1order by 2 desclimit 150