Query editor
WITH RankedTrades AS (SELECTa.tx_hash,a.token_pair,a.token_bought_symbol AS token_bought_symbol_a,a.token_sold_symbol AS token_sold_symbol_a,b.token_bought_symbol AS token_bought_symbol_b,b.token_sold_symbol AS token_sold_symbol_b,a.amount_usd AS amount_usd_a,b.amount_usd AS amount_usd_b,ROW_NUMBER() OVER (PARTITION BY a.tx_hash ORDER BY LEAST(a.amount_usd, b.amount_usd)) AS rnFROMdex_aggregator.trades aINNER JOIN dex_aggregator.trades b ON a.tx_hash = b.tx_hashAND a.token_bought_symbol = b.token_sold_symbolAND a.token_sold_symbol = b.token_bought_symbolWHEREa.project = 'CoW Protocol'AND a.blockchain = 'ethereum'AND a.block_time > now() - INTERVAL '7' dayAND b.project = 'CoW Protocol'AND b.blockchain = 'ethereum'AND b.block_time > now() - INTERVAL '7' day)SELECTtx_hash,token_pair,token_bought_symbol_a,token_sold_symbol_a,token_bought_symbol_b,token_sold_symbol_b,CASE WHEN amount_usd_a < amount_usd_b THEN amount_usd_a ELSE amount_usd_b END AS min_amount_usdFROM RankedTradesWHERE rn = 1