Staking Txns Count | Unstaking Txns Count | Staker Count | Unstaker Count | ROUND("STAKING VOLUME ($MON)",2) | ROUND("UNSTAKING VOLUME ($MON)",2) | Net Staking Volume ($MON) | ROUND("AVG STAKING VOLUME ($MON)",2) | ROUND("AVG UNSTAKING VOLUME ($MON)",2) | ROUND("MEDIAN STAKING VOLUME ($MON)",2) | ROUND("MEDIAN UNSTAKING VOLUME ($MON)",2) | Staking Txn Ratio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2125111 | 1032181 | 641541 | 213073 | 4275979.28 | 4038071.12 | 237908.16 | 2.01 | 3.91 | 0.01 | 0.02 | 0.673 |
Eman-RazStaking/Unstaking Stats
Updated 2025-03-05
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
›
⌄
with table1 as (select count(distinct tx_hash) as "Staking Txns Count",
count(distinct origin_from_address) as "Staker Count", sum(value) as "Staking Volume ($MON)", avg(value) as "Avg Staking Volume ($MON)",
median(value) as "Median Staking Volume ($MON)"
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'),
table2 as (select count(distinct tx_hash) as "Unstaking Txns Count",
count(distinct origin_from_address) as "Unstaker Count", sum(value) as "Unstaking Volume ($MON)", avg(value) as "Avg Unstaking Volume ($MON)",
median(value) as "Median Unstaking Volume ($MON)"
from monad.testnet.fact_traces
where to_address=origin_from_address
and from_address='0x2c9c959516e9aaedb2c748224a41249202ca8be7'
and origin_to_address=from_address and origin_function_signature='0x6fed1ea7'
and type='CALL' and trace_succeeded='TRUE' and block_timestamp::date>='2025-02-18')
select "Staking Txns Count", "Unstaking Txns Count", "Staker Count", "Unstaker Count",
round("Staking Volume ($MON)",2), round("Unstaking Volume ($MON)",2), round(("Staking Volume ($MON)"-"Unstaking Volume ($MON)"),2) as "Net Staking Volume ($MON)",
round("Avg Staking Volume ($MON)",2), round("Avg Unstaking Volume ($MON)",2), round("Median Staking Volume ($MON)",2), round("Median Unstaking Volume ($MON)",2),
round(("Staking Txns Count"/("Staking Txns Count"+"Unstaking Txns Count")),3) as "Staking Txn Ratio"
FROM table1 , table2
Last run: 17 days ago
1
91B
31s