WITH latest_balances AS (
SELECT
owner,
balance,
ROW_NUMBER() OVER (PARTITION BY owner ORDER BY block_timestamp DESC) as rn
FROM solana.core.fact_token_balances
WHERE mint = '8Td15GjwPNtADXrZC3GQqUvarHR9hyNKeVihLi3Spump'
)
SELECT COUNT(DISTINCT owner) as total_holders
FROM latest_balances
WHERE rn = 1
AND balance > 0;