BALANCE_DATE,

sum(balance) as Total_ETH,

count(distinct USER_ADDRESS) as total_Metamask,

Total_ETH/total_Metamask as avg_eth_balancs

from flipside_prod_db.ethereum.erc20_balances

where SYMBOL='ETH' and BALANCE_DATE='2022-06-23'

and lower(USER_ADDRESS) in(

select lower(ORIGIN_FROM_ADDRESS) from ethereum.core.ez_dex_swaps

where ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'

and BLOCK_TIMESTAMP::date <='2022-06-23'

)

and HAS_DECIMAL='0'

group by 1