Query editor
with total_pairs as (select-- date_trunc('day', block_time) as dt,block_time,project,case when token_bought_mint_address > token_sold_mint_addressthen CONCAT(token_bought_mint_address,'-',token_sold_mint_address)else CONCAT(token_sold_mint_address,'-',token_bought_mint_address)end as token_pair,amount_usdfrom dex_solana.trades),pump_pair as (select distinct token_pair, 'pumpdotfun' as pffrom total_pairswhere project = 'pumpdotfun')selectdate_trunc('month', block_time) as dt,COALESCE(pf, 'non-pumpdotfun') as types,sum(amount_usd) as total_usd_amount,count(*) as txsfrom total_pairs tpleft join pump_pair pp using(token_pair)group by 1, 2order by 1, 2 desc