WITH block_gaps AS (
SELECT
BLOCK_TIMESTAMP,
LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS previous_block_timestamp
FROM
lava.core.fact_blocks
WHERE block_timestamp::date >= '2024-07-30'
)
SELECT
AVG(TIMESTAMPDIFF(SECOND, previous_block_timestamp, BLOCK_TIMESTAMP)) AS avg_gap_seconds
FROM
block_gaps
WHERE
previous_block_timestamp IS NOT NULL