i_dan$Td: Total Holders
Updated 2024-12-03
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
›
⌄
WITH wallet_balances AS (
SELECT
wallet
, SUM(bal) AS balance
FROM (SELECT
to_address AS wallet
, SUM(amount) AS bal
FROM avalanche.core.ez_token_transfers
WHERE contract_address = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248')
GROUP BY 1
UNION ALL
SELECT
from_address AS wallet
, SUM(-amount) AS bal
FROM avalanche.core.ez_token_transfers
WHERE contract_address = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248')
GROUP BY 1) AS tr
GROUP BY 1
HAVING balance > 0
)
SELECT
COUNT(DISTINCT wallet) AS Holders
, SUM(balance) AS Total_Supply
FROM wallet_balances
QueryRunArchived: QueryRun has been archived