SELECT

b.ADDRESS AS user_address,

b.AMOUNT,

b.ASSET,

ROW_NUMBER() OVER (PARTITION BY b.ADDRESS ORDER BY b.BLOCK_TIMESTAMP DESC) AS rn

FROM

ton.core.fact_balances b

WHERE

b.ASSET = '0:2F956143C461769579BAEF2E32CC2D7BC18283F40D20BB03E432CD603AC33FFC'

AND b.AMOUNT > 0

SELECT DISTINCT

b.user_address,

b.AMOUNT / POWER(10, m.DECIMALS) AS not_balance

FROM

latest_balances b

JOIN

ton.core.fact_jetton_metadata m

ON

b.ASSET = m.ADDRESS

WHERE

b.rn = 1

AND m.SYMBOL = 'NOT'

ORDER BY

not_balance DESC

LIMIT 5;