WITH token_transfers AS (

SELECT

ACCOUNT_ADDRESS AS holder,

CASE

WHEN transfer_event = 'DepositEvent' THEN AMOUNT / 1e8

WHEN transfer_event = 'WithdrawEvent' THEN -AMOUNT / 1e8

END AS amt

FROM aptos.core.fact_transfers

WHERE TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin'

),

holder_balances AS (

SELECT

holder,

SUM(amt) AS total_balance

FROM token_transfers

GROUP BY holder

HAVING SUM(amt) > 0.1

SELECT

COUNT(DISTINCT holder) AS total_holders

FROM holder_balances;