mohammadhtotal Metamask wallet holders 3
Updated 2022-06-23
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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