Copy of daily count and swappers(arbi)

0-MIDCopy of daily count and swappers(arbi)

Updated 2022-10-16

select BLOCK_TIMESTAMP::date as date, count(distinct ORIGIN_FROM_ADDRESS)as unique_swappers

,count(distinct TX_HASH)as swap_count

, 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 1,4

Run a query to Download Data

flipside