HOURLY | GAS_PER_SECOND | |
|---|---|---|
1 | 2025-02-05 00:00:00.000 | 6083.999722 |
2 | 2025-02-05 01:00:00.000 | 7187.002235 |
3 | 2025-02-05 02:00:00.000 | 7916.237671 |
4 | 2025-02-05 03:00:00.000 | 5348.059251 |
5 | 2025-02-05 04:00:00.000 | 7229.957115 |
6 | 2025-02-05 05:00:00.000 | 8029.730318 |
7 | 2025-02-05 06:00:00.000 | 7275.299164 |
8 | 2025-02-05 07:00:00.000 | 6923.653868 |
9 | 2025-02-05 08:00:00.000 | 7220.3363 |
10 | 2025-02-05 09:00:00.000 | 7305.885364 |
11 | 2025-02-05 10:00:00.000 | 8184.467949 |
12 | 2025-02-05 11:00:00.000 | 7694.106596 |
13 | 2025-02-05 12:00:00.000 | 7754.274728 |
14 | 2025-02-05 13:00:00.000 | 8070.043708 |
15 | 2025-02-05 14:00:00.000 | 10802.402337 |
16 | 2025-02-05 15:00:00.000 | 10240.114699 |
17 | 2025-02-05 16:00:00.000 | 10463.391534 |
18 | 2025-02-05 17:00:00.000 | 9616.803119 |
19 | 2025-02-05 18:00:00.000 | 8951.301084 |
20 | 2025-02-05 19:00:00.000 | 10393.349763 |
Movement TeamAverage Gas per Second (Hourly)
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH gas AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS hourly,
COUNT(DISTINCT DATE_TRUNC('second', block_timestamp)) AS total_seconds,
SUM(gas_used) AS total_gas
FROM
aptos.core.fact_transactions
WHERE
block_timestamp >= CURRENT_DATE - 1
AND TX_TYPE = 'user_transaction'
GROUP BY 1
)
SELECT
hourly,
total_gas / total_seconds AS gas_per_second
FROM gas
ORDER BY hourly;
Last run: 3 months ago
48
2KB
2s