SPLITTER | USERS | |
|---|---|---|
1 | 10 - 100 $BGT | 124788 |
2 | Less Than 1 $BGT | 1029873 |
3 | 100 - 1000 $BGT | 24721 |
4 | 1 - 10 $BGT | 214946 |
5 | More Than 1000 $BGT | 2161 |
Sbhn_NPsubtle-amaranth
Updated 2025-05-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with del as (select
concat('0x', right(topics[1],40)) as delegator,
sum(ethereum.public.udf_hex_to_int(data) / pow(10,18)) as deleg
from berachain.testnet.fact_event_logs
where topics[0] = '0x99966631dd6d6c02c5416ca2369709e025ff974a2f1b3f11c8b74acc67731f0e'
and origin_to_address = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
and contract_address = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
group by 1
)
select
case when deleg < 1 then 'Less Than 1 $BGT'
when deleg >=1 and deleg <10 then '1 - 10 $BGT'
when deleg >=10 and deleg <100 then '10 - 100 $BGT'
when deleg >=100 and deleg <1000 then '100 - 1000 $BGT'
else 'More Than 1000 $BGT' end as splitter,
count(DISTINCT delegator) as users
from del
group by 1
Last run: 12 days ago
5
133B
92s