select
row_number() over (order by BALANCE desc) as rank_id,
USER_ADDRESS ,BALANCE ,AMOUNT_USD , BALANCE_DATE
from flipside_prod_db.ethereum.erc20_balances
where BALANCE_DATE='2022-07-26'
and amount_usd > 1000000
and CONTRACT_ADDRESS ='ETH'
and LABEL is null
and lABEL_TYPE is null
order by 1 asc
limit 20