DEPLOYMENT_DATE | CONTRACTS_CREATED | |
|---|---|---|
1 | 2025-03-28 00:00:00.000 | 226 |
2 | 2025-03-29 00:00:00.000 | 360 |
3 | 2025-03-30 00:00:00.000 | 1436 |
4 | 2025-03-31 00:00:00.000 | 767 |
5 | 2025-04-01 00:00:00.000 | 915 |
6 | 2025-04-02 00:00:00.000 | 973 |
7 | 2025-04-03 00:00:00.000 | 300 |
8 | 2025-04-04 00:00:00.000 | 38 |
9 | 2025-04-06 00:00:00.000 | 112 |
10 | 2025-04-07 00:00:00.000 | 393 |
11 | 2025-04-08 00:00:00.000 | 212 |
12 | 2025-04-09 00:00:00.000 | 172 |
13 | 2025-04-10 00:00:00.000 | 112 |
cryptodatadiveContracts Created Per Day
Updated 2025-04-10
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
CAST(BLOCK_TIMESTAMP AS DATE) AS DEPLOYMENT_DATE,
COUNT(*) AS CONTRACTS_CREATED
FROM mezo.testnet.fact_transactions
WHERE TO_ADDRESS IS NULL
GROUP BY DEPLOYMENT_DATE
ORDER BY DEPLOYMENT_DATE
Last run: about 2 months ago
13
417B
2s