CarlOwOsMetamask vs. Other Platforms (1) Count
Updated 2022-06-23
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 mm_wallets AS (
SELECT DISTINCT from_address
FROM ethereum.core.fact_transactions
WHERE to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
)
SELECT COUNT(DISTINCT tx_hash) AS swaps, 'Metamask' AS platform
FROM ethereum.core.ez_dex_swaps
JOIN mm_wallets ON from_address = origin_from_address
WHERE origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
AND block_timestamp >= '2022-01-01'
UNION ALL
SELECT COUNT(DISTINCT tx_hash) AS swaps, 'Uniswap' AS platform
FROM ethereum.core.ez_dex_swaps
JOIN mm_wallets ON from_address = origin_from_address
WHERE platform = 'uniswap-v2'
AND origin_to_address != '0x881d40237659c251811cec9c364ef91dc08d300c'
AND block_timestamp >= '2022-01-01'
UNION ALL
SELECT COUNT(DISTINCT tx_hash) AS swaps, 'Sushiswap' AS platform
FROM ethereum.core.ez_dex_swaps
JOIN mm_wallets ON from_address = origin_from_address
WHERE platform = 'sushiswap'
AND origin_to_address != '0x881d40237659c251811cec9c364ef91dc08d300c'
AND block_timestamp >= '2022-01-01'
Run a query to Download Data