flipside

    member roles
    talebimorteza_72member roles
    Updated 2022-03-09
    select
    balance_date as date,
    COUNT(CASE WHEN (balance >= 35000 and Balance < 150000) then 1 ELSE NULL END) as NumberOfMember,
    COUNT(CASE WHEN Balance >= 150000 then 1 ELSE NULL END) as NumberOfWhale
    from ethereum.erc20_balances where
    contract_address='0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
    group by date
    Run a query to Download Data