TOTAL_HOLDERS | |
|---|---|
1 | 54888 |
Kruys-Collins$GUI token holders copy
Updated 2025-03-23
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 $MOD token holders @ https://flipsidecrypto.xyz/studio/queries/565782f5-e679-4765-956a-78ab0d4678ac
with base as (
SELECT
ACCOUNT_ADDRESS as Wallet
, AMOUNT/1e6 as amount
FROM aptos.core.fact_transfers
where
token_address = '0xe4ccb6d39136469f376242c31b34d10515c8eaaa38092f804db8e08a8f53c5b2::assets_v1::EchoCoin002'
AND TRANSFER_EVENT = 'DepositEvent'
UNION ALL
SELECT
ACCOUNT_ADDRESS as Wallet
, -AMOUNT/1e6 as amount
FROM aptos.core.fact_transfers
where
token_address = '0xe4ccb6d39136469f376242c31b34d10515c8eaaa38092f804db8e08a8f53c5b2::assets_v1::EchoCoin002'
AND TRANSFER_EVENT = 'WithdrawEvent'
),
refine as (
SELECT
wallet
, SUM (amount) as balance
from base
Group by 1
having balance >= 1
)
SELECT
count(distinct wallet) as total_holders from refine
Last run: about 1 month ago
1
9B
5s