Tier | Total Addresses | |
|---|---|---|
1 | tier01: 1 active weeks | 26473685 |
2 | tier02: 2 active weeks | 3029896 |
3 | tier03: 3 active weeks | 1110581 |
4 | tier04: 4 active weeks | 874852 |
5 | tier05: 5 active weeks | 274173 |
Mrftiusers activity
Updated 1 hour ago
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
›
⌄
-- forked from similar-cyan copy copy @ https://flipsidecrypto.xyz/studio/queries/59097445-e296-40ff-9d20-c19c47fcfa8f
with tbl AS
(
SELECT
from_address AS "Address",
COUNT(DISTINCT date_trunc('week', block_timestamp)) AS "Total active weeks"
FROM
monad.testnet.fact_transactions
where block_timestamp > '2025-02-19 15:00:00.000'
GROUP BY 1
)
SELECT case when "Total active weeks" = 1 then 'tier01: 1 active weeks'
when "Total active weeks" = 2 then 'tier02: 2 active weeks'
when "Total active weeks" = 3 then 'tier03: 3 active weeks'
when "Total active weeks" = 4 then 'tier04: 4 active weeks'
when "Total active weeks" = 5 then 'tier05: 5 active weeks'
when "Total active weeks" = 6 then 'tier06: 6 active weeks'
when "Total active weeks" = 7 then 'tier07: 7 active weeks'
when "Total active weeks" = 8 then 'tier08: 8 active weeks'
when "Total active weeks" = 9 then 'tier09: 9 active weeks'
when "Total active weeks" = 10 then 'tier10: 10 active weeks'
when "Total active weeks" > 10 then 'tier11: more than 10 active weeks'
end as "Tier",
count (DISTINCT "Address") AS "Total Addresses"
from tbl
group by 1
order by 1 asc
Last run: about 1 hour agoAuto-refreshes every 12 hours
5
175B
143s