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
33
34
35
36
›
⌄
-- forked from $TYBG: Total Holders @ https://flipsidecrypto.xyz/studio/queries/61a00b4e-bb3b-45a9-87b3-1f2c551adb90
WITH inflows AS (
SELECT
TO_ADDRESS AS address
, SUM(AMOUNT) AS amount_in
FROM avalanche.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248')
GROUP BY address
),
outflows AS (
SELECT
FROM_ADDRESS AS address
, SUM(AMOUNT) AS amount_out
FROM avalanche.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248')
GROUP BY address
),
final AS (
SELECT
COALESCE(inn.address, out.address) AS wallet,
(COALESCE(inn.amount_in, 0) - COALESCE(out.amount_out, 0)) AS tokens_held, -- Calculate net balance
RANK() OVER (ORDER BY tokens_held DESC) AS rank
FROM inflows AS inn
FULL OUTER JOIN outflows AS out
ON inn.address = out.address
WHERE tokens_held > 0
ORDER BY tokens_held DESC
--LIMIT 20;
)
SELECT
COUNT(wallet) AS Holders
, SUM(tokens_held) AS Total_Supply
FROM final
QueryRunArchived: QueryRun has been archived