jb1992TOP 5 UNISWAP POOIS POLYGON
Updated 2022-10-14Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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