Wikist-oA67h0Gritnova L5 d - Top 10 popular pools on UNISWAP v2 by tx volume
    Updated 2023-02-27
    with my_cte as (
    SELECT
    *
    from ethereum.core.ez_dex_swaps
    where platform = 'uniswap-v2'
    )
    select
    pool_name,
    count(distinct tx_hash) as Swaps,
    count(distinct origin_from_address) as Unique_Senders
    from my_cte
    group by pool_name
    order by Swaps desc
    limit 10
    Run a query to Download Data