Address Rank by Unique Contracts | Total Unique Contracts Interacted | |
|---|---|---|
1 | 167455 | 51 |
Mrftimid-orange
Updated 6 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 address_contract_counts AS (
SELECT
from_address,
COUNT(DISTINCT to_address) AS total_unique_contracts
FROM
monad.testnet.fact_transactions
WHERE
to_address IN (SELECT address FROM monad.testnet.dim_contracts)
GROUP BY
from_address
),
ranked_contract_counts AS (
SELECT
from_address,
total_unique_contracts,
RANK() OVER (ORDER BY total_unique_contracts DESC) AS contract_rank
FROM
address_contract_counts
)
SELECT
contract_rank AS "Address Rank by Unique Contracts",
total_unique_contracts AS "Total Unique Contracts Interacted"
FROM
ranked_contract_counts
WHERE
from_address = LOWER('{{Address}}');
Last run: about 6 hours agoAuto-refreshes every 12 hours
1
13B
25s