OneDataAnalystMetamask Users - Most used NFT platforms
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
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH t0 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') )),
t00 AS ( -- Excluding Adresses that have labels in label table
SELECT DISTINCT ALL_Interacts AS Metamask_users
FROM t0
LEFT JOIN ethereum.core.dim_labels ON ethereum.core.dim_labels.ADDRESS = t0.ALL_Interacts
WHERE ethereum.core.dim_labels.ADDRESS IS NULL ),
t1 AS(
SELECT ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, EVENT_NAME
FROM ethereum.core.fact_event_logs
JOIN t00 ON t00.Metamask_users = ethereum.core.fact_event_logs.ORIGIN_FROM_ADDRESS
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 180
),
t01 AS(
SELECT FROM_ADDRESS AS ORIGIN_FROM_ADDRESS, TO_ADDRESS AS ORIGIN_TO_ADDRESS
FROM ethereum.core.fact_transactions
JOIN t00 ON t00.Metamask_users = ethereum.core.fact_transactions.FROM_ADDRESS
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 180
),
Run a query to Download Data