jb1992TOP 5 UNISWAP POOIS POLYGON
    Updated 2022-10-14
    select contract_address,
    case when contract_address = '0x45dda9cb7c25131df268515131f647d726f50608' then 'USDC/WETH'
    when contract_address = '0x86f1d8390222a3691c28938ec7404a1661e618e0' then 'WETH/WMATIC'
    when contract_address = '0x50eaedb835021e4a108b7290636d62e9765cc6d7' then 'WETH/WBTC'
    when contract_address = '0xa374094527e1673a86de625aa59517c5de346d32' then 'USDC/WMATIC'
    when contract_address = '0x9b08288c3be4f62bbf8d1c20ac9c5e6f9467d8b7' then 'USDT/WMATIC'
    else address_name end as pool_name,
    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'
    group by 1,2
    order by 3 DESC
    limit 5
    Run a query to Download Data