SELECT

owner,

balance,

ROW_NUMBER() OVER (PARTITION BY owner ORDER BY BLOCK_TIMESTAMP DESC) AS rn

FROM solana.core.fact_token_balances

WHERE MINT = 'GbbesPbaYh5uiAZSYNXTc7w9jty1rpg3P9L4JeN4LkKc'

SELECT

COUNT(*) AS num_holders

FROM Latest_Transactions

WHERE rn = 1

AND balance > 0;