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