Top 1% Count | Minimum Active Weeks for Top 1% | |
|---|---|---|
1 | 1135306 | 4 |
Mrftisimilar-bronze copy copy
Updated 9 hours 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
36
›
⌄
-- forked from similar-bronze copy @ https://flipsidecrypto.xyz/studio/queries/f3c970c0-fc9a-47d2-a1c7-7cc5a535cf9d
WITH active_weeks AS (
SELECT
from_address AS "Address",
COUNT(DISTINCT date_trunc('week', block_timestamp)) AS "Total active weeks"
FROM
monad.testnet.fact_transactions
GROUP BY
from_address
),
ranked_addresses AS (
SELECT
"Address",
"Total active weeks",
RANK() OVER (ORDER BY "Total active weeks" DESC) AS active_week_rank
FROM
active_weeks
),
top_1_percent AS (
SELECT
"Address",
"Total active weeks"
FROM
ranked_addresses
WHERE
active_week_rank <= (SELECT ROUND(COUNT(*) * 0.01) FROM ranked_addresses)
)
SELECT
COUNT(*) AS "Top 1% Count",
MIN("Total active weeks") AS "Minimum Active Weeks for Top 1%"
FROM
top_1_percent;
Last run: about 9 hours agoAuto-refreshes every 12 hours
1
13B
47s