Unique contract deployer | Contract deployed | |
|---|---|---|
1 | 1194807 | 6713256 |
Mrftitheoretical-apricot
Updated 22 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tbl AS
(
SELECT
creator_address AS "Address",
COUNT(*) as "Contract deployed",
RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
FROM monad.testnet.dim_contracts
where inserted_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
)
SELECT
count (DISTINCT "Address") as "Unique contract deployer",
sum ("Contract deployed") as "Contract deployed"
from tbl
Last run: about 22 hours agoAuto-refreshes every 12 hours
1
19B
26s