WEEK_NUMBER | AVG_TRANSACTIONS_PER_USER | |
|---|---|---|
1 | Week 1 | 114.35 |
2 | Week 2 | 153.56 |
3 | Week 3 | 127.22 |
4 | Week 4 | 112.6 |
5 | Week 5 | 84.86 |
ejirogabrielethereum average transactions per user
Updated 2024-11-07
999
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 active_users AS (
-- Track users performing DEX swaps on Ethereum using contract_address
SELECT DISTINCT contract_address AS user_address, DATE_TRUNC('week', inserted_timestamp) AS week
FROM ethereum.defi.ez_dex_swaps
WHERE inserted_timestamp >= '2024-10-01' AND inserted_timestamp < '2024-11-01' -- Filter for October
GROUP BY user_address, week
UNION ALL
-- Track users interacting with lending protocols (deposits and borrows)
SELECT DISTINCT contract_address AS user_address, DATE_TRUNC('week', inserted_timestamp) AS week
FROM ethereum.defi.ez_lending_borrows
WHERE inserted_timestamp >= '2024-10-01' AND inserted_timestamp < '2024-11-01'
GROUP BY user_address, week
UNION ALL
-- Track users interacting with lending deposits
SELECT DISTINCT contract_address AS user_address, DATE_TRUNC('week', inserted_timestamp) AS week
FROM ethereum.defi.ez_lending_deposits
WHERE inserted_timestamp >= '2024-10-01' AND inserted_timestamp < '2024-11-01'
GROUP BY user_address, week
UNION ALL
-- Track users interacting with liquid staking (deposits and withdrawals)
SELECT DISTINCT contract_address AS user_address, DATE_TRUNC('week', inserted_timestamp) AS week
FROM ethereum.defi.ez_liquid_staking_deposits
WHERE inserted_timestamp >= '2024-10-01' AND inserted_timestamp < '2024-11-01'
GROUP BY user_address, week
UNION ALL
-- Track users interacting with liquid staking withdrawals
SELECT DISTINCT contract_address AS user_address, DATE_TRUNC('week', inserted_timestamp) AS week
FROM ethereum.defi.ez_liquid_staking_withdrawals
Last run: about 1 month ago
5
89B
4s