boomer77paraswap-new active users
Updated 2022-05-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with raw as (select block_timestamp, from_address, ROW_NUMBER() OVER (partition by from_address Order by block_timestamp asc) AS rank
from ethereum_core.fact_transactions
where to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' and year(block_timestamp) = '2022' and status = 'SUCCESS'),
firsts as (select from_address, date(block_timestamp) as dt
from raw
where rank = 1 and date(block_timestamp) > CURRENT_DATE - 61)
select dt, count(distinct from_address) as new_users
from firsts
group by 1
Run a query to Download Data