WALLET_BALANCE | NO_OF_WALLET_HOLDING_BUSD | |
|---|---|---|
1 | Between 10 USD and 99 USD | 1177031 |
2 | > 100000 | 5711 |
3 | < 10 USD | 1002333 |
4 | Between 1000 USD and 9999 USD | 117373 |
5 | Between 100 USD and 999 USD | 304069 |
6 | Between 10000 USD and 99999 USD | 26105 |
apostleoffinanceBUSD : Wallet Address on Binance
Updated 2025-03-30
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 wallet_usd as (SELECT
symbol,
from_address as users,
sum(amount_usd) as amounts_usd
FROM bsc.core.ez_token_transfers
WHERE symbol = 'BUSD'
GROUP BY 1,2
HAVING amounts_usd > 0
)
SELECT '< 10 USD' as Wallet_Balance,
COUNT(DISTINCT users) No_of_wallet_holding_BUSD
FROM wallet_usd
WHERE amounts_usd < 10
UNION
SELECT 'Between 10 USD and 99 USD' as Wallet_Balance,
COUNT(DISTINCT users) No_of_wallet_holding_BUSD
FROM wallet_usd
WHERE amounts_usd > 10 and amounts_usd <= 99
UNION
SELECT 'Between 100 USD and 999 USD' as Wallet_Balance,
COUNT(DISTINCT users) No_of_wallet_holding_BUSD
FROM wallet_usd
WHERE amounts_usd > 100 and amounts_usd <= 999
UNION
SELECT 'Between 1000 USD and 9999 USD' as Wallet_Balance,
COUNT(DISTINCT users) No_of_wallet_holding_BUSD
FROM wallet_usd
WHERE amounts_usd > 1000 and amounts_usd <= 9999
UNION
SELECT 'Between 10000 USD and 99999 USD' as Wallet_Balance,
Last run: 3 months ago
6
200B
105s