select DISTINCT ORIGIN_FROM_ADDRESS as DISTINCT_WALLET --1271763 wallets

from ethereum.core.fact_event_logs

where ORIGIN_TO_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')

and EVENT_REMOVED = 'false'

and TX_STATUS = 'SUCCESS'),

table_2 as (

select USER_ADDRESS as wallets_engaged --14073 wallets

from flipside_prod_db.ethereum.erc20_balances

inner join table_1

on flipside_prod_db.ethereum.erc20_balances.USER_ADDRESS = table_1.DISTINCT_WALLET

where CONTRACT_ADDRESS = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')

and BALANCE_DATE = CURRENT_DATE)

select count(wallets_engaged)/count(DISTINCT_WALLET) * 100

from table_1 x

full outer join table_2 y

on x.DISTINCT_WALLET = y.wallets_engaged