adambalaMember Roles
    Updated 2022-03-14
    with IFFF
    as (
    select distinct user_address ,balance
    ,date_trunc('day',balance_date) as date
    from ethereum.erc20_balances
    where balance_date::date > current_date-1
    and contract_address ='0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
    group by 1,2,3
    )

    select date,count(distinct user_address ),
    IFF( balance >=35000, IFF(balance between 35000 and 150000,'member','WHALE'),'OTHER')

    from IFFF
    group by 1,3


    Run a query to Download Data