DAY | NEW_CONTRACTS | |
|---|---|---|
1 | 2025-04-01 00:00:00.000 | 973 |
2 | 2025-04-02 00:00:00.000 | 1047 |
3 | 2025-04-03 00:00:00.000 | 409 |
4 | 2025-04-04 00:00:00.000 | 256 |
5 | 2025-04-05 00:00:00.000 | 144 |
6 | 2025-04-06 00:00:00.000 | 252 |
7 | 2025-04-07 00:00:00.000 | 533 |
8 | 2025-04-08 00:00:00.000 | 395 |
9 | 2025-04-09 00:00:00.000 | 375 |
10 | 2025-04-10 00:00:00.000 | 627 |
11 | 2025-04-11 00:00:00.000 | 575 |
12 | 2025-04-12 00:00:00.000 | 214 |
13 | 2025-04-13 00:00:00.000 | 582 |
14 | 2025-04-14 00:00:00.000 | 868 |
15 | 2025-04-15 00:00:00.000 | 396 |
16 | 2025-04-16 00:00:00.000 | 337 |
17 | 2025-04-17 00:00:00.000 | 380 |
18 | 2025-04-18 00:00:00.000 | 144 |
19 | 2025-04-19 00:00:00.000 | 363 |
20 | 2025-04-20 00:00:00.000 | 302 |
kentoNew Contracts
Updated 2025-04-30
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE(created_block_timestamp) AS day,
COUNT(*) AS new_contracts
FROM mezo.testnet.dim_contracts
WHERE created_block_timestamp BETWEEN '2025-04-01' AND '2025-05-01'
GROUP BY day
ORDER BY day;
Last run: about 1 month ago
30
962B
1s