daily count per hour(poly)

0-MIDdaily count per hour(poly)

Updated 2022-10-17

select BLOCK_TIMESTAMP::date as date,round(count(distinct TX_HASH)/24)as swap_count_per_hour

, 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,3

Run a query to Download Data

flipside