USER_ADDRESS | CONTRACT_INTERACTIONS | UNIQUE_CONTRACTS | |
|---|---|---|---|
1 | 0xc7edfecdd70e330f0849fa00b736a70f977d8678 | 2702790 | 2 |
2 | 0x4c6348bf16fea56f3de86553c0653b817bca799a | 2452209 | 2 |
3 | 0x051785102854b9b9c93c504d9675ffda7a12e07f | 1663110 | 4 |
4 | 0xa5a68ed167431afe739846a22597786ba2da85df | 1035549 | 1 |
5 | 0x89fc331e7a3eebe3d63c000927b79c47f455399f | 1005312 | 1 |
6 | 0x7c34da3ca7e10cf47376ef34f04e758374d2d283 | 988827 | 1 |
7 | 0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d83 | 949069 | 125 |
8 | 0x0a215135f235ffcf52b7a2116bcd7e8c5579e209 | 567913 | 186 |
9 | 0xca8316e1471dbe4080b281ff6ffbc88d00c123a3 | 555773 | 1 |
10 | 0xcf36de4fcb20dfa6f76a14649e8dbdce3a18d010 | 531132 | 8 |
11 | 0x3c09f46d9b1f498bb30bf42bad3a1ceca71962c1 | 468113 | 2 |
12 | 0x2f43659a11d689e892577d49f01d79cf0559f496 | 438671 | 1 |
13 | 0xd51507999b432771d9ec416fb23500dfea5182f1 | 430376 | 31 |
14 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | 404083 | 4 |
15 | 0xcc8dd60a8cd21205d077a6feb43c9bc9ed70fa18 | 388983 | 332 |
16 | 0xc2b3c1c9ca12207a3d1bf3be03475d57e057425b | 379825 | 1 |
17 | 0x04a071c2bd5b7c5420c3acec8bbfe97387427a81 | 319053 | 3 |
18 | 0x6840312379be5114b47a4b9a69e10957c816936a | 314206 | 1 |
19 | 0x882dd2862a4b22651be47ea63f233594173b12d8 | 313328 | 97 |
20 | 0x469381d77b755e5b92246a29c9ab586d15b6ebc9 | 307894 | 100 |
Monad Metrics Guildtop users by contract interactions
Updated 3 days 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
›
⌄
WITH contract_addresses AS (
SELECT address FROM monad.testnet.dim_contracts
),
-- Step 1: Get all interactions where either side is a contract
interactions AS (
SELECT
tx_hash,
block_timestamp,
CASE
WHEN from_address NOT IN (SELECT address FROM contract_addresses) THEN from_address
WHEN to_address NOT IN (SELECT address FROM contract_addresses) THEN to_address
ELSE NULL
END AS user_address,
CASE
WHEN from_address IN (SELECT address FROM contract_addresses) THEN from_address
WHEN to_address IN (SELECT address FROM contract_addresses) THEN to_address
ELSE NULL
END AS contract_address
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19 15:00'
-- Ensure one side is a user and one is a contract
AND (
from_address IN (SELECT address FROM contract_addresses)
OR to_address IN (SELECT address FROM contract_addresses)
)
AND (
from_address NOT IN (SELECT address FROM contract_addresses)
OR to_address NOT IN (SELECT address FROM contract_addresses)
)
),
-- Step 2: Aggregate stats
transaction_and_contract_stats AS (
SELECT
user_address,
Last run: about 10 hours ago
...
5000
269KB
400s