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

owner_address as "Address",

token_holdings as "OLAS Balance",

round(token_holdings/223401 * 100, 3) as "(%) of Supply"

from last_address_and_balance_pair

where token_holdings > 0

order by "OLAS Balance" desc