DAY | CONTRACT_COUNT | |
---|---|---|
1 | 2025-03-29 00:00:00.000 | 364 |
2 | 2025-03-30 00:00:00.000 | 1458 |
3 | 2025-03-31 00:00:00.000 | 770 |
4 | 2025-04-01 00:00:00.000 | 973 |
5 | 2025-04-02 00:00:00.000 | 1047 |
6 | 2025-04-03 00:00:00.000 | 409 |
7 | 2025-04-04 00:00:00.000 | 256 |
8 | 2025-04-05 00:00:00.000 | 144 |
9 | 2025-04-06 00:00:00.000 | 252 |
10 | 2025-04-07 00:00:00.000 | 533 |
11 | 2025-04-08 00:00:00.000 | 395 |
12 | 2025-04-09 00:00:00.000 | 375 |
13 | 2025-04-10 00:00:00.000 | 162 |
cryptodatadiveDaily Contract Deployments
Updated 2025-04-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH contracts AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
ADDRESS AS CONTRACT_ADDRESS,
CREATOR_ADDRESS
FROM mezo.testnet.dim_contracts
)
SELECT
DATE_TRUNC('day', CREATED_BLOCK_TIMESTAMP) AS DAY,
COUNT(*) AS CONTRACT_COUNT
FROM contracts
GROUP BY 1
ORDER BY 1;
Last run: 3 months ago
13
419B
1s