HOLDERS | BREAKDOWN | |
|---|---|---|
1 | 32629 | d. 1K-10K WLFI |
2 | 12313 | c. 100-1K WLFI |
3 | 3503 | b. 10-100 WLFI |
4 | 258 | h. +10M WLFI |
5 | 2233 | a. Below 50 WLFI |
6 | 7806 | f. 100K-1M WLFI |
7 | 25746 | e. 10K-100K WLFI |
8 | 1382 | g. 1M-10M WLFI |
zyroqWLFI Holders distribution
Updated 2025-03-21
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
›
⌄
WITH top_wallets as (
SELECT
min(LAST_ACTIVITY_BLOCK_TIMESTAMP) as date,
max(CURRENT_BAL) as max_balance,
USER_ADDRESS
from ethereum.core.ez_current_balances
where CONTRACT_ADDRESS = lower('0xdA5e1988097297dCdc1f90D4dFE7909e847CBeF6')
group by 3
)
SELECT
count(DISTINCT USER_ADDRESS) as holders,
case
when max_balance <= 50 then 'a. Below 50 WLFI'
when max_balance <= 100 then 'b. 10-100 WLFI'
when max_balance <= 1000 then 'c. 100-1K WLFI'
when max_balance <= 10000 then 'd. 1K-10K WLFI'
when max_balance <= 100000 then 'e. 10K-100K WLFI'
when max_balance <= 1000000 then 'f. 100K-1M WLFI'
when max_balance <= 10000000 then 'g. 1M-10M WLFI'
when max_balance > 10000000 then 'h. +10M WLFI' end as breakdown
from top_wallets
group by 2
Last run: 3 months ago
8
198B
28s