ArioTop 10 Pools based on # Swap
    Updated 2023-10-10
    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

    Run a query to Download Data