HOUR | CONTRACTS_DEPLOYED | |
|---|---|---|
1 | 2025-02-19 00:00:00.000 | 24 |
2 | 2025-02-19 01:00:00.000 | 35 |
3 | 2025-02-19 02:00:00.000 | 10 |
4 | 2025-02-19 03:00:00.000 | 22 |
5 | 2025-02-19 04:00:00.000 | 48 |
6 | 2025-02-19 05:00:00.000 | 31 |
7 | 2025-02-19 06:00:00.000 | 44 |
8 | 2025-02-19 07:00:00.000 | 35 |
9 | 2025-02-19 08:00:00.000 | 112 |
10 | 2025-02-19 09:00:00.000 | 289 |
11 | 2025-02-19 10:00:00.000 | 564 |
12 | 2025-02-19 11:00:00.000 | 629 |
13 | 2025-02-19 12:00:00.000 | 668 |
14 | 2025-02-19 13:00:00.000 | 7056 |
15 | 2025-02-19 14:00:00.000 | 6326 |
16 | 2025-02-19 15:00:00.000 | 4530 |
17 | 2025-02-19 16:00:00.000 | 5649 |
18 | 2025-02-19 17:00:00.000 | 6069 |
19 | 2025-02-19 18:00:00.000 | 4124 |
20 | 2025-02-19 19:00:00.000 | 3225 |
Kruys-Collinspleasant-teal
Updated 2025-02-20
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE_TRUNC('hour', created_block_timestamp) AS hour,
COUNT(*) AS contracts_deployed
FROM monad.testnet.dim_contracts
WHERE created_block_timestamp >= '2025-02-19'
GROUP BY hour
ORDER BY hour;
Last run: 23 days ago
46
1KB
2s