HOUR | TOTAL_HOURLY_ADDRESS | |
|---|---|---|
1 | 2025-02-19 16:00:00.000 | 5649 |
2 | 2025-02-19 17:00:00.000 | 6069 |
3 | 2025-02-19 18:00:00.000 | 4124 |
4 | 2025-02-19 19:00:00.000 | 3225 |
5 | 2025-02-19 20:00:00.000 | 2631 |
6 | 2025-02-19 21:00:00.000 | 2267 |
7 | 2025-02-19 22:00:00.000 | 2137 |
8 | 2025-02-19 23:00:00.000 | 1962 |
9 | 2025-02-20 00:00:00.000 | 2109 |
10 | 2025-02-20 01:00:00.000 | 3025 |
11 | 2025-02-20 02:00:00.000 | 3662 |
12 | 2025-02-20 03:00:00.000 | 5069 |
13 | 2025-02-20 04:00:00.000 | 5225 |
14 | 2025-02-20 05:00:00.000 | 5387 |
15 | 2025-02-20 06:00:00.000 | 5633 |
16 | 2025-02-20 07:00:00.000 | 5769 |
17 | 2025-02-20 08:00:00.000 | 5876 |
18 | 2025-02-20 09:00:00.000 | 5989 |
19 | 2025-02-20 10:00:00.000 | 6241 |
20 | 2025-02-20 11:00:00.000 | 5267 |
pepperatziTotal Contracts Created Over Tiime
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with base as (
select
created_block_timestamp,
address,
creator_address,
from monad.testnet.dim_contracts
where date_trunc('hour', created_block_timestamp) >= '2025-02-19 16:00:00'
)
select
date_trunc('hour', created_block_timestamp) as hour,
count(distinct address) as total_hourly_address
from base
group by 1
order by 1 asc
Last run: 28 days ago
31
1KB
1s