select
a.BLOCK_TIMESTAMP::date as date,
count(distinct (signers[0])) as wallets
FROM solana.core.fact_events a
join solana.core.fact_transactions b
on a.tx_id = b.tx_id
where a.PROGRAM_ID = 'EverSFw9uN5t1V8kS3ficHUcKffSjwpGzUSGd7mgmSks'
and a.BLOCK_TIMESTAMP >='2022-01-01'
and a.succeeded = True
group by 1
order by 1