SELECT

platform,

SUM(amount_in_usd) AS total_volume,

COUNT(DISTINCT tx_hash) AS total_swaps

FROM

near.defi.ez_dex_swaps

WHERE

amount_in_usd IS NOT NULL

GROUP BY

platform

),

platform_ranking AS (

SELECT

platform,

total_volume,

total_swaps,

ROW_NUMBER() OVER (ORDER BY total_volume DESC) AS volume_rank,

ROW_NUMBER() OVER (ORDER BY total_swaps DESC) AS swaps_rank

FROM

d_ex_swap_volumes

platform,

total_volume,

total_swaps,

volume_rank,

swaps_rank

platform_ranking

ORDER BY

volume_rank, swaps_rank

LIMIT 1;