select

count(distinct PUBKEY_SCRIPT_ADDRESS) as active_addresses,

date_trunc('week', block_timestamp) as week,

case when block_timestamp::date='2020-05-11' then 'halving'

else 'other' end as category

from bitcoin.core.fact_inputs

where block_timestamp::date > '2019-12-11' and block_timestamp::date < '2020-8-11'

group by 2,3)

, btc_currenthalving as

(select

count(distinct PUBKEY_SCRIPT_ADDRESS) as active_addresses,

date_trunc('week', block_timestamp) as week,

from bitcoin.core.fact_inputs

where block_timestamp::date > '2023-11-01'

group by 2)

select * from btc_prehalving