ACTION | TXNS | ADDRESS | AMT | Avg Stake (AXS) | Median Stake (AXS) | Max Stake (AXS) | |
|---|---|---|---|---|---|---|---|
1 | Unstake | 58162 | 12963 | 20881262.0468621 | 359.018982271 | 2.61963687 | 416000 |
2 | Stake | 302953 | 31847 | 24784922.1564061 | 81.811113131 | 0.6442159127 | 349052.726665661 |
hess6. Total Numbers Since 2025
Updated 2025-04-09
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with staking as ( select block_timestamp::Date as date,
tx_hash,
DECODED_LOG:_user::string as staker,
DECODED_LOG:_amount/pow(10,18) as stake_amount
from ronin.core.ez_decoded_event_logs
where contract_address = lower('0x05b0bb3c1c320b280501b86706c3551995bc8571')
and event_name = 'Staked'
and block_timestamp::Date >= '2025-01-01')
,
unstaking as ( select block_timestamp::Date as date,
tx_hash,
DECODED_LOG:_user::string as unstaker,
DECODED_LOG:_amount/pow(10,18) as unstake_amount
from ronin.core.ez_decoded_event_logs
where contract_address = lower('0x05b0bb3c1c320b280501b86706c3551995bc8571')
and event_name = 'Unstaked'
and block_timestamp::Date >= '2025-01-01')
select 'Stake' as action,
count(distinct tx_hash) as txns,
count(distinct staker) as address,
sum(stake_amount) as amt,
avg(stake_amount) as "Avg Stake (AXS)",
median(stake_amount) as "Median Stake (AXS)",
max(stake_amount) as "Max Stake (AXS)"
from staking
group by 1
union
select 'Unstake' as action,
count(distinct tx_hash) as txns,
count(distinct unstaker) as address,
sum(unstake_amount) as amt,
avg(unstake_amount) as "Avg Stake (AXS)",
median(unstake_amount) as "Median Stake (AXS)",
max(unstake_amount) as "Max Stake (AXS)"
from unstaking
Last run: 18 days ago
2
157B
28s