SPLITTER | USERS | |
|---|---|---|
1 | 100 - 1000 $BGT | 24497 |
2 | 1 - 10 $BGT | 213296 |
3 | More Than 1000 $BGT | 2135 |
4 | 10 - 100 $BGT | 124311 |
5 | Less Than 1 $BGT | 1027825 |
Sbhn_NPsubtle-amaranth
Updated 2025-02-04
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: 3 months ago
5
133B
167s