Afonso_DiazHolders Breakdown
Updated 2025-03-09
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
29
30
31
32
33
34
35
36
›
⌄
with
deposits as (
select
to_address as receiver,
sum(amount) as volume
from avalanche.core.ez_token_transfers
where contract_address = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'
group by 1
),
withdraws as (
select
from_address as sender,
sum(amount) as volume
from avalanche.core.ez_token_transfers
where contract_address = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'
group by 1
),
main as (
select
receiver as holder,
nvl(deposits.volume, 0) - nvl(withdraws.volume, 0) as balance
from deposits
left join withdraws on receiver = sender
where nvl(deposits.volume, 0) - nvl(withdraws.volume, 0) > 0
)
select
case
when balance < 1000 then 'Plankton 🐠 (<1K $QI)'
when balance between 1000 and 10000 then 'Crabs 🦀 (1K - 10K $QI)'
when balance between 10000 and 100000 then 'Sharks 🦈 (10K - 100K $QI)'
when balance between 100000 and 1000000 then 'Whales 🐋 (100K - 1M $QI)'
else 'Kraken 🏴☠️ (>1M $QI)'
QueryRunArchived: QueryRun has been archived