TYPE | USERS | |
|---|---|---|
1 | Existing Users | 144791 |
2 | New Users | 225736 |
dannyamahNew and Existing Users
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with marinade as (
select
block_timestamp,
from_address,
to_address,
row_number () over (partition by from_address order by block_timestamp asc) as rn
from
monad.testnet.fact_transactions
where
block_timestamp >= '2025-02-19'
)
select
case when rn = '1' then 'New Users'
else 'Existing Users'
end as type,
count (distinct from_address) as Users
from marinade
group by 1
Last run: 27 days ago
2
48B
2s