Sajjadiiimr esi69
    Updated 2022-06-24
    with holder as (
    select DISTINCT ORIGIN_FROM_ADDRESS as holders
    from ethereum.core.ez_dex_swaps
    where ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c'
    )
    select avg(balance)
    from holder a
    inner join flipside_prod_db.ethereum.erc20_balances b
    on a.holders = b.USER_ADDRESS
    where symbol = 'ETH'
    and CONTRACT_ADDRESS = 'ETH'
    and BALANCE_DATE::date = '2022-06-22'
    Run a query to Download Data