CONCAT(symbol_in, ' -> ', symbol_out) AS swap_pair,

CONCAT(token_in_contract, ' -> ', token_out_contract) AS token_pair,

COUNT(DISTINCT tx_hash) AS swaps,

SUM(amount_in_usd) AS volume

near.defi.ez_dex_swaps

platform = 'v2.ref-finance.near'

AND amount_in_usd IS NOT NULL

GROUP BY

swap_pair,

token_pair

ORDER BY

volume DESC,

swaps DESC

10;