Query editor
WITH ranked_swaps AS (SELECTDATE_TRUNC('day', evt_block_time) AS evt_date,CONCAT(t1.symbol, '-', t2.symbol) AS swapPair,SUM(w.swapVol /CASEWHEN t1.blockchain = 'bnb' THEN 1e18ELSE 1e6END) AS swapVol_sum,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('day', evt_block_time)ORDER BY SUM(w.swapVol /CASEWHEN t1.blockchain = 'bnb' THEN 1e18ELSE 1e6END) DESC) AS rnFROM woofi_multichain.wooppv2_evt_wooswap AS wJOIN tokens.erc20 AS t1ON w.fromToken = t1.contract_address AND t1.blockchain = w.chainJOIN tokens.erc20 AS t2ON w.toToken = t2.contract_address AND t2.blockchain = w.chainWHEREw.evt_block_time >= DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '1' month - INTERVAL '1' dayGROUP BYDATE_TRUNC('day', evt_block_time),CONCAT(t1.symbol, '-', t2.symbol))SELECTevt_date,swapPair,swapVol_sumFROM ranked_swapsWHERE rn <= 10ORDER BYevt_date DESC,swapVol_sum DESC;