mehdimarjanMetaMask vs. Other Platforms
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH metamask AS (
SELECT COUNT(DISTINCT TX_HASH) AS "Number of Transactions",
SUM(AMOUNT_IN_USD) AS "Amount In USD",
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Number of Unique Swappers",
(SUM(AMOUNT_IN_USD) / COUNT(DISTINCT ORIGIN_FROM_ADDRESS)) AS "Average USD Value Per Wallet",
'MetaMask' AS "Label"
FROM ethereum.core.ez_dex_swaps
WHERE ORIGIN_TO_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
),
others AS (
SELECT COUNT(DISTINCT TX_HASH) AS "Number of Transactions",
SUM(AMOUNT_IN_USD) AS "Amount In USD",
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Number of Unique Swappers",
(SUM(AMOUNT_IN_USD) / COUNT(DISTINCT ORIGIN_FROM_ADDRESS)) AS "Average USD Value Per Wallet",
'Other Platforms' AS "Label"
FROM ethereum.core.ez_dex_swaps
WHERE ORIGIN_TO_ADDRESS <> lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
)
SELECT * FROM metamask
UNION
SELECT * FROM others
Run a query to Download Data