pouya_22Total Metamask Users - Average value of ETH held in wallets on June 25
    Updated 2022-06-25
    with metsmask_holders as (select
    distinct origin_from_address as address
    from ethereum.core.fact_event_logs
    where contract_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C'))

    select
    balance_date as date,
    avg(balance)
    from flipside_prod_db.ethereum.erc20_balances
    where date = current_date
    and symbol = 'ETH'
    and contract_address = 'ETH'
    and user_address in (select address from metsmask_holders)
    group by 1
    Run a query to Download Data