price AS (

SELECT

DATE(HOUR) as HOUR,

AVG(PRICE) as price

from

ethereum.core.fact_hourly_token_prices

where

symbol = 'WBTC'

group by

DATE(HOUR)

),

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.core.ez_miner_rewards r1

WHERE

r1.block_number = b.block_number

AND NOT EXISTS (

SELECT

1

FROM

bitcoin.core.ez_miner_rewards r2

WHERE

r2.block_number = r1.block_number - 1

AND r2.block_reward = r1.block_reward * 2

)

)