SajjadiiiTotal Metamask Users 4
Updated 2022-06-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with list as (select
distinct ORIGIN_FROM_ADDRESS as users
from ethereum.core.ez_dex_swaps
where ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c' -- metamask Swap Router contract
and ORIGIN_FUNCTION_SIGNATURE = '0x5f575529')
select
case when users in (select distinct ORIGIN_FROM_ADDRESS
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and CONTRACT_ADDRESS = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' union select distinct ORIGIN_FROM_ADDRESS from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0x3019227b2b8493e45bf5d25302139c9a2713bf15'
and CONTRACT_ADDRESS = '0x3019227b2b8493e45bf5d25302139c9a2713bf15') then 'staking' else 'non staking ' end as type ,
count (users) as member
from list
group by 1
Run a query to Download Data