Total Addresses in Top 1% | Minimum Unique Contracts for Top 1% | |
|---|---|---|
1 | 72558 | 71 |
Mrfticontracts interaction
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
›
⌄
WITH contract_interactions AS (
SELECT
from_address AS "Address",
COUNT(DISTINCT to_address) AS "Unique Contracts Interacted"
FROM monad.testnet.fact_transactions
WHERE to_address IN (SELECT address FROM monad.testnet.dim_contracts)
GROUP BY 1
),
ranked_addresses AS (
SELECT
"Address",
"Unique Contracts Interacted",
NTILE(100) OVER (ORDER BY "Unique Contracts Interacted" DESC) AS percentile
FROM contract_interactions
),
top_1_percent AS (
SELECT
"Address",
"Unique Contracts Interacted"
FROM ranked_addresses
WHERE percentile = 1 -- Top 1% by unique contract interactions
)
SELECT
COUNT(DISTINCT "Address") AS "Total Addresses in Top 1%",
MIN("Unique Contracts Interacted") AS "Minimum Unique Contracts for Top 1%"
FROM top_1_percent;
Last run: about 4 hours agoAuto-refreshes every 12 hours
1
12B
109s