SELECT

ACCOUNT_ID,

BALANCE,

ROW_NUMBER() OVER (PARTITION BY ACCOUNT_ID ORDER BY LEDGER_SEQUENCE DESC) AS rn

FROM stellar.core.fact_accounts

WHERE MASTER_WEIGHT > 0

SELECT ACCOUNT_ID, BALANCE

FROM ranked_accounts

WHERE rn = 1

ORDER BY BALANCE DESC

LIMIT 50;