DATE | Total Contracts Deployed | Cumulative Deployed Contracts | |
|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 48487 | 48487 |
2 | 2025-02-20 00:00:00.000 | 106848 | 155335 |
3 | 2025-02-21 00:00:00.000 | 95381 | 250716 |
4 | 2025-02-22 00:00:00.000 | 82158 | 332874 |
5 | 2025-02-23 00:00:00.000 | 111471 | 444345 |
6 | 2025-02-24 00:00:00.000 | 150344 | 594689 |
7 | 2025-02-25 00:00:00.000 | 279517 | 874206 |
8 | 2025-02-26 00:00:00.000 | 522395 | 1396601 |
9 | 2025-02-27 00:00:00.000 | 384711 | 1781312 |
10 | 2025-02-28 00:00:00.000 | 349016 | 2130328 |
11 | 2025-03-01 00:00:00.000 | 277296 | 2407624 |
12 | 2025-03-02 00:00:00.000 | 228862 | 2636486 |
13 | 2025-03-03 00:00:00.000 | 208138 | 2844624 |
14 | 2025-03-04 00:00:00.000 | 234498 | 3079122 |
15 | 2025-03-05 00:00:00.000 | 201411 | 3280533 |
16 | 2025-03-06 00:00:00.000 | 202421 | 3482954 |
17 | 2025-03-07 00:00:00.000 | 239576 | 3722530 |
18 | 2025-03-08 00:00:00.000 | 178402 | 3900932 |
19 | 2025-03-09 00:00:00.000 | 184477 | 4085409 |
20 | 2025-03-10 00:00:00.000 | 203926 | 4289335 |
Mrftiunhappy-magenta
Updated 24 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH tbl AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
creator_address AS "Address",
COUNT(*) as "Total Contracts deployed"
FROM monad.testnet.dim_contracts
GROUP BY 1,2
)
SELECT
date_trunc (day, CREATED_BLOCK_TIMESTAMP) as date,
sum ("Total Contracts deployed") as "Total Contracts Deployed",
sum ("Total Contracts Deployed") over (order by date) as "Cumulative Deployed Contracts"
from tbl
where date > '2025-02-18 00:00:00.000'
group by 1
order by 1
Last run: about 24 hours agoAuto-refreshes every 12 hours
28
1KB
5s