DATE | Contract Deployer | Contract Deployed | |
|---|---|---|---|
1 | 2025-04-10 00:00:00.000 | 35 | 187 |
2 | 2025-04-09 00:00:00.000 | 22 | 375 |
3 | 2025-04-08 00:00:00.000 | 22 | 395 |
4 | 2025-04-07 00:00:00.000 | 7 | 533 |
5 | 2025-04-06 00:00:00.000 | 4 | 252 |
6 | 2025-04-05 00:00:00.000 | 1 | 144 |
7 | 2025-04-04 00:00:00.000 | 4 | 256 |
8 | 2025-04-03 00:00:00.000 | 61 | 409 |
9 | 2025-04-02 00:00:00.000 | 146 | 1047 |
10 | 2025-04-01 00:00:00.000 | 159 | 973 |
11 | 2025-03-31 00:00:00.000 | 112 | 770 |
12 | 2025-03-30 00:00:00.000 | 62 | 1458 |
13 | 2025-03-29 00:00:00.000 | 15 | 364 |
alfredfx10Contracts (Deployed & Deployer)
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with Contracts AS
(SELECT creator_address AS "Address",COUNT(*) AS "Contract deployed",
CREATED_BLOCK_TIMESTAMP
FROM mezo.testnet.dim_contracts
GROUP BY 1,3
)
SELECT DATE_TRUNC(day, CREATED_BLOCK_TIMESTAMP) AS Date,
COUNT(DISTINCT "Address") AS "Contract Deployer",
SUM ("Contract deployed") AS "Contract Deployed"
FROM Contracts
GROUP BY 1
ORDER BY 1 DESC
Last run: about 2 months ago
13
457B
1s