SELECT
CONCAT(symbol_in, '->', symbol_out) AS swap_pair,
COUNT(DISTINCT tx_hash) AS swaps,
FROM
kaia.defi.ez_dex_swaps
WHERE
platform = 'capybara'
AND symbol_in IS NOT NULL
AND symbol_out IS NOT NULL
GROUP BY
symbol_in, symbol_out
ORDER BY
swaps DESC
LIMIT 10