mohammadhtotal Metamask wallet holders 3
    Updated 2022-06-23
    select count(distinct ORIGIN_FROM_ADDRESS) as metamask_users,
    CASE
    when ORIGIN_FROM_ADDRESS in (select distinct ORIGIN_FROM_ADDRESS
    from ethereum.core.fact_event_logs
    where (EVENT_NAME ='AddLiquidity' OR EVENT_NAME ='Borrow' OR EVENT_NAME ='Staked' OR EVENT_NAME ='TransferSentToL2'
    OR EVENT_NAME ='Mint' )) then 'Has_conditions' else 'No_conditions'
    end as activity
    from ethereum.core.ez_dex_swaps
    where ORIGIN_TO_ADDRESS=lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    group by activity
    Run a query to Download Data