SELECT

ACCOUNT_ADDRESS AS token_account,

OWNER,

BLOCK_TIMESTAMP,

BALANCE AS total_balance_of_owner,

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

FROM solana.core.fact_token_balances

WHERE MINT = 'Ez3nzG9ofodYCvEmw73XhQ87LWNYVRM2s7diB5tBZPyM'

),

last_address_and_balance_pair as (SELECT

token_account,

OWNER as owner_address,

total_balance_of_owner as token_holdings,

BLOCK_TIMESTAMP as last_update_date

FROM RankedBalances

rn = 1 AND total_balance_of_owner <> 0

ORDER BY total_balance_of_owner desc)

select COUNT(*) AS address_count

from last_address_and_balance_pair