count(distinct ACCOUNT_ADDRESS) AS wallet,

FROM

solana.core.fact_token_balances

WHERE

mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' -- Filter for mSOL token

AND SUCCEEDED

AND BLOCK_TIMESTAMP = (

SELECT MAX(BLOCK_TIMESTAMP)

FROM solana.core.fact_token_balances sub

WHERE sub.ACCOUNT_ADDRESS = solana.core.fact_token_balances.ACCOUNT_ADDRESS

AND sub.mint = solana.core.fact_token_balances.mint -- Ensure same mint for subquery

AND balance>0