select distinct(ORIGIN_FROM_ADDRESS) as address

from ethereum.core.fact_event_logs

where CONTRACT_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C') and block_timestamp> '2021-01-01'

),

metamask_wallets_latest_details as (

select distinct(a.user_address) as var1, a.balance as var2, a.amount_usd as var3, symbol, balance_date

from flipside_prod_db.ethereum.erc20_balances a

inner join Wallets b

on a.user_address= b.address

where balance_date::date ='2022-06-23'

)

select avg(var2) as Average_eth_holding, avg(var3) as Average_holdings_USD, count(var1) as Number_of_wallets

from metamask_wallets_latest_details

where balance_date::date ='2022-06-23' and symbol= 'ETH' and var3 > 0 and var3 < 1000000 and

var1 not in (select address from ethereum.core.dim_contracts) and var1 not in (select address from ethereum.core.dim_labels )

order by var2 desc