with first_tx as (
select
signers[0] as wallet,
min(date(block_timestamp)) as first_tx_date
from solana.core.fact_events
where
program_id = '{{param_1}}'
group by 1
),
new_wallets AS (
SELECT
first_tx_date,
count(distinct wallet) as new_wallets
FROM first_tx
WHERE first_tx_date between CURRENT_DATE()-60 and current_date()-1
GROUP BY 1 )
select * from new_wallets