Address | Reward (Amount) | |
|---|---|---|
1 | 33414 | 2636382.97225121 |
hess15. Total Rewards
Updated 2025-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with base as (select block_timestamp::Date as date,
tx_hash,
DECODED_LOG:_user::string as staker,
DECODED_LOG:_amount/pow(10,18) as amount,
DECODED_LOG:_token::string as token_address
from ronin.core.ez_decoded_event_logs
where contract_address = lower('0x05b0bb3c1c320b280501b86706c3551995bc8571')
and event_name = 'RewardClaimed'
and block_timestamp >= '2025-01-01')
select
count(distinct staker) as "Address",
sum(amount) as "Reward (Amount)"
from base
Last run: 16 days ago
1
26B
13s