with
tab1 as (
SELECT
Pool_name,
count(distinct tx_hash) as "# Swap"
from
avalanche.core.ez_dex_swaps
where
BLOCK_TIMESTAMP >= '2023-01-01'
and platform = '{{platform}}'
group by 1
)
select
Pool_name,
"# Swap"
from tab1
order by "# Swap" desc
limit 10