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