SELECT

MAX(block_id) AS max_block,

MAX(block_timestamp) AS max_time_utc

FROM

osmosis.core.fact_blocks

),

missing AS (

SELECT

block_id,

LAG(

block_id,

1

) over (

ORDER BY

block_id ASC

) AS prev_block_id

FROM

(

SELECT

DISTINCT block_id

FROM

osmosis.core.fact_blocks

WHERE

block_id > 4068078

)

),

gaps AS (

SELECT

DATE_TRUNC(

'd',

b.block_timestamp

) AS _date,

A.block_id,

A.prev_block_id,

A.block_id - A.prev_block_id - 1 AS gap