📅 Date | 📝 Daily Deployed Contracts | 👥 Unique Contract Creators | 📈 Cumulative Contracts | 📊 7-Day Moving Average | |
|---|---|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 32594 | 15401 | 32594 | 32594 |
2 | 2025-02-20 00:00:00.000 | 106848 | 27175 | 139442 | 69721 |
3 | 2025-02-21 00:00:00.000 | 95381 | 23558 | 234823 | 78274.333 |
4 | 2025-02-22 00:00:00.000 | 82158 | 22208 | 316981 | 79245.25 |
5 | 2025-02-23 00:00:00.000 | 111471 | 31022 | 428452 | 85690.4 |
6 | 2025-02-24 00:00:00.000 | 150344 | 40379 | 578796 | 96466 |
7 | 2025-02-25 00:00:00.000 | 279517 | 94270 | 858313 | 122616.142 |
8 | 2025-02-26 00:00:00.000 | 522395 | 164114 | 1380708 | 192587.714 |
9 | 2025-02-27 00:00:00.000 | 384711 | 151487 | 1765419 | 232282.428 |
10 | 2025-02-28 00:00:00.000 | 349016 | 168991 | 2114435 | 268516 |
11 | 2025-03-01 00:00:00.000 | 277296 | 133758 | 2391731 | 296392.857 |
12 | 2025-03-02 00:00:00.000 | 228862 | 102252 | 2620593 | 313163 |
13 | 2025-03-03 00:00:00.000 | 208138 | 91460 | 2828731 | 321419.285 |
14 | 2025-03-04 00:00:00.000 | 234498 | 116594 | 3063229 | 314988 |
15 | 2025-03-05 00:00:00.000 | 201411 | 83953 | 3264640 | 269133.142 |
16 | 2025-03-06 00:00:00.000 | 202421 | 57761 | 3467061 | 243091.714 |
17 | 2025-03-07 00:00:00.000 | 239576 | 101962 | 3706637 | 227457.428 |
18 | 2025-03-08 00:00:00.000 | 178402 | 66909 | 3885039 | 213329.714 |
19 | 2025-03-09 00:00:00.000 | 184477 | 56155 | 4069516 | 206989 |
20 | 2025-03-10 00:00:00.000 | 203926 | 62903 | 4273442 | 206387.285 |
Monad Data Enginefluttering-azure
Updated 2025-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH daily_contracts AS (
SELECT
DATE_TRUNC('day', created_block_timestamp) AS date,
COUNT(*) AS contracts_deployed,
COUNT(DISTINCT creator_address) AS unique_creators
FROM MONAD.testnet.dim_contracts
WHERE created_block_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
)
SELECT
date AS "📅 Date",
contracts_deployed AS "📝 Daily Deployed Contracts",
unique_creators AS "👥 Unique Contract Creators",
SUM(contracts_deployed) OVER (ORDER BY date) AS "📈 Cumulative Contracts",
AVG(contracts_deployed) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS "📊 7-Day Moving Average"
FROM daily_contracts
ORDER BY date;
Last run: 15 days ago
27
2KB
2s