EVENT_NAME | |
|---|---|
1 | XPClaimed |
2 | Factory__Claimed |
3 | HoneyLocker__Claimed |
4 | TokensClaimed |
5 | ReverseClaimed |
6 | Claim |
7 | UserClaimableUpdate |
8 | StaminaClaimed |
9 | ClaimReward |
10 | ArtClaimedData |
11 | AirdropClaimed |
12 | NewClaimContract |
13 | Claimed |
14 | ClaimConditionsUpdated |
15 | ToggleClaim |
16 | RewardClaimed |
17 | ClaimBid |
18 | RewardsClaimed |
19 | ClaimContractDeployed |
Sbhn_NPlost-amethyst
Updated 2025-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with wallets as (
select ORIGIN_FROM_ADDRESS ,
count (DISTINCT CONTRACT_ADDRESS) num_cont
from berachain.testnet.ez_decoded_event_logs
group by 1
)
select case when num_cont = 1 then 'Only one contract'
when num_cont BETWEEN 2 and 5 then '2 - 5 contracts'
when num_cont BETWEEN 5 and 10 then '5 - 10 contracts'
when num_cont BETWEEN 10 and 50 then '10 - 50 contracts'
when num_cont BETWEEN 50 and 100 then '50 - 100 contracts'
when num_cont BETWEEN 100 and 500 then '100 - 500 contracts'
else 'More then 500 contracts'
end range ,
count (ORIGIN_FROM_ADDRESS) num_wallets
from wallets
group by 1
Last run: 3 months ago
19
357B
26s