0-MIDnew users daily
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (
select min(BLOCK_TIMESTAMP::date) as date, ORIGIN_FROM_ADDRESS as new_swappers
, case
when (ORIGIN_TO_ADDRESS ='0xe592427a0aece92de3edee1f18e0157c05861564'
or ORIGIN_TO_ADDRESS='0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45') then 'Uniswap'
when ORIGIN_TO_ADDRESS='0x1b02da8cb0d097eb8d57a175b88c7d8b47997506' then 'Sushiswap' end as rutrs
from arbitrum.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 2,3)
select date , rutrs,count(new_swappers) as new_users
from tab1
group by 1,2
Run a query to Download Data