Sbhn_NPPolygon Top 5 Pools on Uniswap by Number of Swaps
    Updated 2022-10-16
    select contract_address,
    count (distinct tx_hash) as Swaps_Count,
    count (distinct origin_from_address) as Swappers_Count
    from polygon.core.fact_event_logs t1 full outer join polygon.core.dim_labels t2 on t1.contract_address = t2.address
    where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564'
    and event_name = 'Swap'
    and tx_status = 'SUCCESS'
    and block_timestamp >= '2022-06-01'
    group by 1
    order by 2 DESC
    limit 5
    Run a query to Download Data