eferMetamask daily swappers (ETH, BSC, Polygon) in last 30 days
Updated 2023-04-13
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
›
⌄
-- Metamask Ethereum Swap Router: 0x881d40237659c251811cec9c364ef91dc08d300c
-- Metamask Polygon Swap Router: 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31
-- Metamask BSC Swap Router: 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31
WITH metamask_ethereum_users AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT FROM_ADDRESS) AS users
FROM ethereum.core.fact_transactions
WHERE TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
AND date > CURRENT_DATE - 30
GROUP BY date
ORDER BY date ASC
), metamask_polygon_users AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT FROM_ADDRESS) AS users
FROM polygon.core.fact_transactions
WHERE TO_ADDRESS='0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31'
AND date > CURRENT_DATE - 30
GROUP BY date
ORDER BY date ASC
), metamask_bsc_users AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT FROM_ADDRESS) AS users
FROM bsc.core.fact_transactions
WHERE TO_ADDRESS='0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31'
AND date > CURRENT_DATE - 30
GROUP BY date
ORDER BY date ASC
)
SELECT
CAST(eth.date AS DATE) AS date,
COALESCE(eth.users, 0) AS mainnet_users,
Run a query to Download Data