CoinConverseUntitled Query
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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