account_id,

balance

FROM stellar.core.fact_accounts

QUALIFY ROW_NUMBER() OVER (PARTITION BY account_id ORDER BY block_timestamp DESC) = 1

ORDER BY balance DESC

limit 1000