eferMetamask daily swappers (ETH only)
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
›
⌄
WITH metamask_ethereum_users AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT FROM_ADDRESS) AS users,
SUM(users) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative
FROM ethereum.core.fact_transactions
WHERE TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
GROUP BY date
ORDER BY date ASC
), avg AS (
SELECT AVG(users) as avg_users FROM metamask_ethereum_users
)
SELECT
date,
users,
cumulative,
AVG(users) OVER(ORDER BY date ROWS BETWEEN {{MA}} PRECEDING AND CURRENT ROW) AS MA{{MA}},
CASE
WHEN users > {{peak_threshold}} * avg.avg_users THEN 'Peak'
ELSE 'Normal_day'
END AS peak_over_threshold
FROM metamask_ethereum_users, avg
Run a query to Download Data