Query editor
WITH node_operator_wallets AS (SELECT wallet_address as wallet_idFROM dune.serotonin_data.result_solana_node_operators_render_ionet_ore_nosana),common_swaps AS (SELECTDATE_TRUNC('month', dt.block_time) AS month,dt.token_pair,SUM(amount_usd) AS volFROM dex_solana.trades dtWHERE dt.trader_id IN (SELECT wallet_id FROM node_operator_wallets)AND dt.block_time >= CURRENT_TIMESTAMP - INTERVAL '2' yearAND dt.token_pair IS NOT NULLAND dt.token_pair <> ''GROUP BY DATE_TRUNC('month', dt.block_time), dt.token_pair),top_30_pairs AS (SELECT token_pairFROM common_swapsGROUP BY token_pairORDER BY SUM(vol) DESCLIMIT 30),swaps_with_others AS (SELECTmonth,CASEWHEN token_pair IN (SELECT token_pair FROM top_30_pairs) THEN token_pairELSE 'Other'END AS token_pair,SUM(vol) AS volFROM common_swapsGROUP BY month,CASEWHEN token_pair IN (SELECT token_pair FROM top_30_pairs) THEN token_pairELSE 'Other'END)SELECTmonth,token_pair,volFROM swaps_with_othersORDER BY month, vol DESC