with activities as (

SELECT

PUBKEY_SCRIPT_ADDRESS,

date_trunc('day',block_timestamp) as date

FROM bitcoin.core.fact_inputs

GROUP BY 1, 2

),

active_wallets as (

SELECT

date_trunc('month',date) as month,

PUBKEY_SCRIPT_ADDRESS,

count(date) as n_txn

FROM activities

GROUP BY 1 , 2

HAVING n_txn >=4 --

SELECT

date_trunc('month', block_timestamp) as date,

count(DISTINCT b.PUBKEY_SCRIPT_ADDRESS) as n_engaged_users

FROM bitcoin.core.fact_inputs LEFT JOIN active_wallets b using(PUBKEY_SCRIPT_ADDRESS)

GROUP BY 1

ORDER BY 1 DESC