Query editor
WITH per_token AS (SELECTblock_date,CASEWHEN token_bought_symbol IN ('SOL','WSOL','USDC','USDT','USDS')THEN token_sold_symbolELSE token_bought_symbolEND AS token,sum(amount_usd) AS token_volFROM dex_solana.tradesWHERE project = 'pumpswap'AND block_time >= now() - interval '30' dayAND amount_usd IS NOT NULLGROUP BY 1, 2),ranked AS (SELECTblock_date, token, token_vol,sum(token_vol) OVER (PARTITION BY block_date) AS day_vol,row_number() OVER (PARTITION BY block_date ORDER BY token_vol DESC) AS rnFROM per_token),bucketed AS (SELECTblock_date,day_vol,CASE WHEN rn <= 8 THEN token ELSE 'Others' END AS token,token_volFROM ranked)SELECTblock_date,token,100.0 * sum(token_vol) / day_vol AS pct_of_dayFROM bucketedGROUP BY block_date, token, day_volORDER BY block_date, pct_of_day DESC