Query editor
SELECTtoken_pair,SUM(token_bought_amount / NULLIF(token_sold_amount, 0)) AS volume_ratio_sum,AVG(token_bought_amount / NULLIF(token_sold_amount, 0)) AS avg_ratioFROM dex.tradesWHERE blockchain = 'mantle'AND block_time >= NOW() - INTERVAL '30' dayGROUP BY token_pairORDER BY avg_ratio DESC;