SELECT

platform,

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

COUNT(DISTINCT tx_hash) AS swap_count,

ROW_NUMBER() OVER (PARTITION BY platform ORDER BY COUNT(DISTINCT tx_hash) DESC) AS rank

FROM

kaia.defi.ez_dex_swaps

WHERE

block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'

GROUP BY

platform, symbol_in, symbol_out

platform,

swap_pair,

swap_count

ranked_swap_pairs

rank <= 4

ORDER BY

platform, swap_count DESC;