-- forked from Richlist - Worldcoin @ https://flipsidecrypto.xyz/edit/queries/aaa30e64-3ff0-4f63-a4f8-d9dc20fb0f17

with latest_balances as (

select

user_address,

balance / pow(10, 18) as adjusted_balance,

block_timestamp as latest_update,

row_number() over (

partition by user_address

order by

block_timestamp desc

) as rank_latest_update

from

ethereum.core.fact_token_balances

where

contract_address = lower('0xf8C3527CC04340b208C854E985240c02F7B7793f') qualify rank_latest_update = 1

),

richlist as (

select

*,

row_number() over (

order by

adjusted_balance desc

) as rank_richest_wallets

from

latest_balances

),

final as (

select

*

from

richlist

left join ethereum.core.dim_labels on user_address = address

where