CoinConverseUntitled Query
    Updated 2022-06-25
    with staking_wallets as (select distinct origin_from_address
    from ethereum.core.ez_dex_swaps
    where symbol_out = 'WETH' and token_out = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
    select count(distinct origin_from_address) as metamask_holders, case
    when origin_from_address in (select origin_from_address from staking_wallets) then 'staking wallets'
    when origin_from_address not in (select origin_from_address from staking_wallets) then 'non-staking wallets'
    end as event_name
    from ethereum.core.fact_event_logs
    where contract_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    group by 2
    Run a query to Download Data