RANGE | NUM_WALLETS | |
|---|---|---|
1 | 10 - 50 transactions | 2502885 |
2 | More then 500 transactions | 142970 |
3 | 100 - 500 transactions | 1116448 |
4 | 50 - 100 transactions | 956625 |
5 | Only one transaction | 3278952 |
6 | 2 - 5 transactions | 24510554 |
7 | 5 - 10 transactions | 1676201 |
saeedmzn[Berachain review] - users distribution
Updated 2025-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with wallets as (
select FROM_ADDRESS ,
count (TX_HASH) num_txn
from berachain.testnet.fact_transactions
group by 1
)
select case when num_txn = 1 then 'Only one transaction'
when num_txn BETWEEN 2 and 5 then '2 - 5 transactions'
when num_txn BETWEEN 5 and 10 then '5 - 10 transactions'
when num_txn BETWEEN 10 and 50 then '10 - 50 transactions'
when num_txn BETWEEN 50 and 100 then '50 - 100 transactions'
when num_txn BETWEEN 100 and 500 then '100 - 500 transactions'
else 'More then 500 transactions'
end range ,
count (FROM_ADDRESS) num_wallets
from wallets
group by 1
Last run: about 1 month ago
7
237B
39s