AVG_INTER_TX_TIME_SECS | MIN_INTER_TX_TIME_SECS | MAX_INTER_TX_TIME_SECS | MEDIAN_INTER_TX_TIME_SECS | |
|---|---|---|---|---|
1 | 1492.59 | 0 | 149887 | 8 |
Kruys-Collinspsychological-cyan
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH inter_transaction_time AS (
SELECT
from_address,
DATEDIFF(
'second',
LAG(block_timestamp) OVER (PARTITION BY from_address ORDER BY block_timestamp),
block_timestamp
) AS inter_tx_time_secs
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19'
)
SELECT
ROUND(AVG(inter_tx_time_secs), 2) AS avg_inter_tx_time_secs,
ROUND(MIN(inter_tx_time_secs), 2) AS min_inter_tx_time_secs,
ROUND(MAX(inter_tx_time_secs), 2) AS max_inter_tx_time_secs,
ROUND(MEDIAN(inter_tx_time_secs), 2) AS median_inter_tx_time_secs
FROM inter_transaction_time
WHERE inter_tx_time_secs IS NOT NULL;
Last run: 24 days ago
1
22B
1s