HOUR | HOURLY_TX | |
|---|---|---|
1 | 2025-04-13 03:00:00.000 | 52936 |
2 | 2025-04-13 02:00:00.000 | 147653 |
3 | 2025-04-13 01:00:00.000 | 145481 |
4 | 2025-04-13 00:00:00.000 | 144208 |
5 | 2025-04-12 23:00:00.000 | 140509 |
6 | 2025-04-12 22:00:00.000 | 145881 |
7 | 2025-04-12 21:00:00.000 | 157940 |
8 | 2025-04-12 20:00:00.000 | 176641 |
9 | 2025-04-12 19:00:00.000 | 195304 |
10 | 2025-04-12 18:00:00.000 | 202360 |
11 | 2025-04-12 17:00:00.000 | 200410 |
12 | 2025-04-12 16:00:00.000 | 194022 |
13 | 2025-04-12 15:00:00.000 | 196616 |
14 | 2025-04-12 14:00:00.000 | 202130 |
15 | 2025-04-12 13:00:00.000 | 190212 |
16 | 2025-04-12 12:00:00.000 | 178097 |
17 | 2025-04-12 11:00:00.000 | 171128 |
18 | 2025-04-12 10:00:00.000 | 181597 |
19 | 2025-04-12 09:00:00.000 | 185983 |
20 | 2025-04-12 08:00:00.000 | 182449 |
Movement TeamDaily Transactions
Updated 2 days ago
9
1
2
3
4
5
6
7
8
›
⌄
Select
date_trunc('Hour',BLOCK_TIMESTAMP) as Hour,
count(*) as Hourly_tx
from aptos.core.fact_transactions
where BLOCK_TIMESTAMP >= current_date - 1
group by 1
order by 1 desc
Last run: 1 day ago
28
980B
1s