SELECT

ACCOUNT_ADDRESS AS holder,

CASE

WHEN transfer_event = 'DepositEvent' THEN AMOUNT

WHEN transfer_event = 'WithdrawEvent' THEN -AMOUNT

END AS amt

FROM aptos.core.fact_transfers

WHERE TOKEN_ADDRESS = '0xe88ae9670071da40a9a6b1d97aab8f6f1898fdc3b8f1c1038b492dfad738448b::coin::Donk'

),

holder_balances AS (

SELECT

holder,

SUM(amt) AS total_balance

FROM token_transfers

GROUP BY holder

HAVING SUM(amt) > 0

SELECT

COUNT(DISTINCT holder) AS total_holders

FROM holder_balances;