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'

),

address_list as (

select var1 as wallets_address

from metamask_wallets_latest_details

where 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

),

--Address_list has the list of all the wallets we have considered while calculatingthe total number of wallets

transactions_of_wallet as (

select event_name as event, origin_from_address, tx_hash, contract_address, block_timestamp, contract_name

from ethereum.core.fact_event_logs a

inner join address_list b

on b.wallets_address = a.origin_from_address

),