HOUR | CONTRACTS | |
|---|---|---|
1 | 2025-02-22 02:00:00.000 | 1574 |
2 | 2025-02-22 01:00:00.000 | 1795 |
3 | 2025-02-22 00:00:00.000 | 1841 |
4 | 2025-02-21 23:00:00.000 | 2002 |
5 | 2025-02-21 22:00:00.000 | 2088 |
6 | 2025-02-21 21:00:00.000 | 3286 |
7 | 2025-02-21 20:00:00.000 | 5011 |
8 | 2025-02-21 19:00:00.000 | 3392 |
9 | 2025-02-21 18:00:00.000 | 3826 |
10 | 2025-02-21 17:00:00.000 | 4049 |
11 | 2025-02-21 16:00:00.000 | 4045 |
12 | 2025-02-21 15:00:00.000 | 5013 |
13 | 2025-02-21 14:00:00.000 | 5385 |
14 | 2025-02-21 13:00:00.000 | 5772 |
15 | 2025-02-21 12:00:00.000 | 5717 |
16 | 2025-02-21 11:00:00.000 | 5688 |
17 | 2025-02-21 10:00:00.000 | 5754 |
18 | 2025-02-21 09:00:00.000 | 5361 |
19 | 2025-02-21 08:00:00.000 | 5200 |
20 | 2025-02-21 07:00:00.000 | 4621 |
datavortexstatutory-orange
Updated 2025-02-22
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
COUNT(DISTINCT contract_address) AS contracts
FROM monad.testnet.fact_event_logs
WHERE contract_address IS NOT NULL
AND block_timestamp >= '2025-02-19'
GROUP BY 1
ORDER BY hour DESC;
Last run: 3 months ago
75
2KB
2s