address,

balance,

SUM(balance) OVER (ORDER BY balance DESC) AS address_balance,

row_number() OVER (ORDER BY balance DESC) AS rank

FROM

near.gov.fact_staking_pool_daily_balances

WHERE

date = current_date - 1

LIMIT 10--Nakamoto coefficient