cheeyoung-kekWhale 2.2
    Updated 2022-07-26
    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
    Run a query to Download Data