flipside

    Untitled Query
    superflyUntitled Query
    Updated 2022-10-28
    with metamask_users as (
    select distinct origin_from_address as addr
    from ethereum.core.ez_dex_swaps
    where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c')

    select avg(balance)
    from flipside_prod_db.ethereum.erc20_balances
    where balance_date = current_date - 1 and user_address in (select addr from metamask_users) and contract_address = 'ETH'
    Run a query to Download Data