Address Rank by Active Weeks | Total Active Weeks by Address | |
|---|---|---|
1 | 4071976 | 1 |
Mrftiactive weeks
Updated 4 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
›
⌄
-- forked from conscious-violet @ https://flipsidecrypto.xyz/studio/queries/2a7e7a4f-fc0c-4854-9de5-53d2064cac85
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
)
SELECT
active_week_rank AS "Address Rank by Active Weeks",
"Total active weeks" AS "Total Active Weeks by Address"
FROM
ranked_addresses
WHERE
"Address" = LOWER('{{Address}}');
Last run: about 4 hours agoAuto-refreshes every 12 hours
1
13B
114s