past_halving_date AS (

SELECT DISTINCT

block_timestamp AS halving_date,

block_number AS block_height

FROM

bitcoin.core.fact_blocks b

WHERE

NOT EXISTS (

SELECT

1

FROM

bitcoin.gov.ez_miner_rewards r1

WHERE

r1.block_number = b.block_number

AND NOT EXISTS (

SELECT

1

FROM

bitcoin.gov.ez_miner_rewards r2

WHERE

r2.block_number = r1.block_number - 1

AND r2.block_reward = r1.block_reward * 2

)

)

),

future_halving_date AS (

SELECT

TIMESTAMPADD(

SECOND,

(

(

FLOOR(

(

SELECT

block_number