boomer77MIM holders daily
    Updated 2022-02-07
    with raw as (select balance_date, user_address, balance
    from ethereum.erc20_balances
    where contract_address = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3' and balance > 0 and balance_date >= '2022-01-23')

    select balance_date, count(distinct user_address) as mim_holder, sum(balance) as Marketcap
    from raw
    group by 1
    Run a query to Download Data