Query editor
-- LCMM BUBBLES Daily v4-- Graduates + crowd + flow + the pipe: who bought, who ever sold.with grads as (select cast(mint as varchar) as mintfrom pumpdotfun_solana.pump_evt_completeeventwhere evt_block_time >= date_trunc('day', now()) - interval '1' dayand evt_block_time < date_trunc('day', now())group by 1),legs as (select token_bought_mint_address as mint, trader_id, amount_usd, 'b' as sidefrom dex_solana.tradeswhere block_time >= date_trunc('day', now()) - interval '1' dayand block_time < date_trunc('day', now())and project in ('pumpdotfun', 'pumpswap', 'pump_amm')union allselect token_sold_mint_address, trader_id, amount_usd, 's' as sidefrom dex_solana.tradeswhere block_time >= date_trunc('day', now()) - interval '1' dayand block_time < date_trunc('day', now())and project in ('pumpdotfun', 'pumpswap', 'pump_amm'))select g.mint,count(distinct l.trader_id) as traders,sum(l.amount_usd) as vol_usd,count(distinct case when l.side = 's' then l.trader_id end) as sellersfrom grads gleft join legs l on l.mint = g.mintgroup by 1