Staking Txns Count | Number of Stakers | |
---|---|---|
1 | n=1 Txn | 445601 |
2 | n=2 Txn | 77316 |
3 | >100 Txns | 2406 |
4 | 3-10 Txns | 98634 |
5 | 11-50 Txns | 15894 |
6 | 51-100 Txns | 1690 |
Eman-RazDistribution of Users By Staking Count
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select origin_from_address, count(distinct tx_hash), case
when count(distinct tx_hash)=1 then 'n=1 Txn'
when count(distinct tx_hash)=2 then 'n=2 Txn'
when count(distinct tx_hash)>=3 and count(distinct tx_hash)<=10 then '3-10 Txns'
when count(distinct tx_hash)>=11 and count(distinct tx_hash)<=50 then '11-50 Txns'
when count(distinct tx_hash)>=51 and count(distinct tx_hash)<=100 then '51-100 Txns'
when count(distinct tx_hash)>100 then '>100 Txns'
end as "Staking Txns Count"
from monad.testnet.fact_traces
where from_address=origin_from_address
and to_address='0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and origin_to_address=to_address and origin_function_signature='0xd5575982'
and type='CALL' and trace_address='ORIGIN' and trace_succeeded='TRUE' and block_timestamp::date>='2025-02-18'
group by 1)
select "Staking Txns Count", count(distinct origin_from_address) as "Number of Stakers"
from tab1
group by 1
Last run: 14 days ago
6
119B
12s