HOUR | CONTRACTS_DEPLOYED | TOTAL_CONTRACTS_DEPLOYED | |
|---|---|---|---|
1 | 2025-03-11 09:00:00.000 | 15723 | 4411913 |
2 | 2025-02-20 06:00:00.000 | 5633 | 79178 |
3 | 2025-03-01 15:00:00.000 | 12176 | 2328964 |
4 | 2025-03-09 13:00:00.000 | 10266 | 4012674 |
5 | 2025-03-04 02:00:00.000 | 6211 | 2860708 |
6 | 2025-03-10 21:00:00.000 | 10499 | 4269239 |
7 | 2025-03-15 23:00:00.000 | 8547 | 5763630 |
8 | 2025-02-25 13:00:00.000 | 7145 | 671508 |
9 | 2025-03-07 20:00:00.000 | 8472 | 3699135 |
10 | 2025-02-24 05:00:00.000 | 5976 | 471166 |
11 | 2025-03-05 08:00:00.000 | 9410 | 3169941 |
12 | 2025-03-11 16:00:00.000 | 13808 | 4527475 |
13 | 2025-02-19 09:00:00.000 | 289 | 1231 |
14 | 2025-02-18 20:00:00.000 | 38 | 518 |
15 | 2025-03-06 15:00:00.000 | 8532 | 3420877 |
16 | 2025-03-07 09:00:00.000 | 29288 | 3587856 |
17 | 2025-03-09 23:00:00.000 | 4044 | 4085990 |
18 | 2025-03-10 20:00:00.000 | 10121 | 4258740 |
19 | 2025-02-24 19:00:00.000 | 7245 | 577788 |
20 | 2025-02-23 17:00:00.000 | 5570 | 420449 |
Pine AnalyticsMonad 3
Updated 2025-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
hour,
contracts_deployed,
SUM(contracts_deployed) OVER (ORDER BY hour) AS total_contracts_deployed
FROM (
SELECT
DATE_TRUNC('hour', created_block_timestamp) AS hour,
COUNT(DISTINCT address) AS contracts_deployed
FROM monad.testnet.dim_contracts
GROUP BY 1
)
WHERE hour > '2025-02-18'
Last run: about 1 month ago
...
753
30KB
3s