total count per swapper(poly)

0-MIDtotal count per swapper(poly)

Updated 2022-10-18

select count(distinct ORIGIN_FROM_ADDRESS)as unique_swappers

,count(distinct TX_HASH)as swap_count,swap_count/unique_swappers as swap_count_per_swapper

, case

when (ORIGIN_TO_ADDRESS ='0xe592427a0aece92de3edee1f18e0157c05861564'

or ORIGIN_TO_ADDRESS='0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') then 'Uniswap'

when ORIGIN_TO_ADDRESS='0x1b02da8cb0d097eb8d57a175b88c7d8b47997506' then 'Sushiswap' end as rutrs

from polygon.core.fact_event_logs

where (ORIGIN_TO_ADDRESS='0xe592427a0aece92de3edee1f18e0157c05861564'or

ORIGIN_TO_ADDRESS='0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45'or

ORIGIN_TO_ADDRESS='0x1b02da8cb0d097eb8d57a175b88c7d8b47997506')

and TX_STATUS='SUCCESS'

group by 4

Run a query to Download Data

flipside