i_dan$TYBG: Total Holders
Updated 2024-11-18
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 inflows AS (
SELECT
TO_ADDRESS AS address
, SUM(AMOUNT) AS amount_in
FROM base.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')
GROUP BY address
),
outflows AS (
SELECT
FROM_ADDRESS AS address
, SUM(AMOUNT) AS amount_out
FROM base.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE')
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