TOTAL_HOLDERS | |
|---|---|
1 | 533 |
datavortexTotal Holders on SWELL
Updated 2025-04-25
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 transfers AS (
SELECT
decoded_log:from::STRING AS from_address,
decoded_log:to::STRING AS to_address,
(decoded_log:value::FLOAT) / 1e18 AS amount
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Transfer'
AND contract_address = LOWER('0x18d33689AE5d02649a859A1CF16c9f0563975258')
),
received AS (
SELECT
to_address AS wallet,
SUM(amount) AS total_received
FROM transfers
GROUP BY to_address
),
-- total tokens sent per address
sent AS (
SELECT
from_address AS wallet,
SUM(amount) AS total_sent
FROM transfers
GROUP BY from_address
)
SELECT
COUNT(*) AS total_holders
FROM (
SELECT
r.wallet
FROM received r
LEFT JOIN sent s ON r.wallet = s.wallet
WHERE COALESCE(r.total_received, 0) - COALESCE(s.total_sent, 0) > 0
) AS holders
Last run: 14 days ago
1
7B
1s