SELECT

MAX(block_id) AS max_block,

MIN(block_id) AS min_block,

MAX(block_id) - MIN(block_id) AS block_range

FROM

osmosis.core.fact_blocks

WHERE block_timestamp > CURRENT_DATE() - 1

),

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

)

),

gaps AS (

SELECT

DATE_TRUNC(

'd',

b.block_timestamp

) AS _date,

A.block_id,