TX | USERS | |
---|---|---|
1 | 500 | 22 |
2 | 92 | 12 |
3 | 567 | 1 |
4 | 1677 | 1 |
5 | 849 | 2 |
6 | 121 | 9 |
7 | 118 | 5 |
8 | 358 | 2 |
9 | 154 | 4 |
10 | 2007 | 1 |
11 | 263 | 1 |
12 | 241 | 1 |
13 | 1731 | 1 |
14 | 4316 | 1 |
15 | 293 | 2 |
16 | 401 | 2 |
17 | 5326 | 1 |
18 | 56 | 31 |
19 | 859 | 1 |
20 | 1008 | 4 |
hessShare of Transactions by New Users (30D)
Updated 2025-05-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with new as ( select min(block_timestamp) as date,
from_address
from avalanche.core.fact_transactions
group by 2
)
,
new_address as ( select DISTINCT from_address
from new
where date >= current_date - 30)
,
final as (select count(DISTINCT(tx_hash)) as tx,
from_address
from avalanche.core.fact_transactions
where from_address not in (select address from avalanche.core.dim_labels)
and from_address in (select from_address from new_address)
and block_timestamp::date >= current_date - 30
group by 2)
select tx,
count(DISTINCT(from_address)) as users
from final
group by 1
Last run: 3 months ago
687
6KB
35s