SELECT

BLOCK_NUMBER, USER_ADDRESS, CURRENT_BAL_UNADJ

FROM ethereum.core.ez_balance_deltas

WHERE CONTRACT_ADDRESS = '0x23581767a106ae21c074b2276D25e5C3e136a68b'

), LAST_SNAPSHOT AS (

SELECT

TB1.USER_ADDRESS AS HOLDER,

TB1.CURRENT_BAL_UNADJ AS NFTS

FROM BALANCES TB1

LEFT OUTER JOIN BALANCES TB2

ON (

TB1.USER_ADDRESS = TB2.USER_ADDRESS

AND TB1.BLOCK_NUMBER < TB2.BLOCK_NUMBER

)

WHERE TB2.USER_ADDRESS IS NULL

AND NFTS!=0

ORDER BY NFTS DESC

COALESCE(TB2.ADDRESS_NAME, TB1.HOLDER) AS ADDRESS,

TB1.HOLDER AS HOLDER,

TB1.NFTS

FROM LAST_SNAPSHOT TB1

LEFT JOIN (

SELECT * FROM ethereum.core.dim_labels

) TB2

ON (TB1.HOLDER = TB2.ADDRESS)

ORDER BY NFTS DESC