OneDataAnalystMetaMask users
Updated 2022-06-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
WITH t1 AS ( -- ALL Wallets interacts with MetaMask Swap feature on Ethereum
SELECT DISTINCT C1 AS ALL_Interacts
FROM(
SELECT DISTINCT ORIGIN_FROM_ADDRESS AS C1
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C')
OR CONTRACT_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C')
UNION
SELECT DISTINCT FROM_ADDRESS
FROM ethereum.core.fact_transactions
WHERE TO_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C') )),
t2 AS (
SELECT DISTINCT ALL_Interacts AS Metamask_users
FROM t1
LEFT JOIN ethereum.core.dim_labels ON ethereum.core.dim_labels.ADDRESS = t1.ALL_Interacts
WHERE ethereum.core.dim_labels.ADDRESS IS NULL )
Run a query to Download Data