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;