SELECT

owner,

balance,

ROW_NUMBER() OVER (PARTITION BY owner ORDER BY block_timestamp DESC) as rn

FROM solana.core.fact_token_balances

WHERE mint = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump'

SELECT COUNT(DISTINCT owner) as total_holders

FROM latest_balances

WHERE rn = 1

AND balance > 0;