with gmv2_txs as (
select
distinct tx_id
from solana.core.fact_events
where date(block_timestamp) between '2022-07-21' and current_date()-1 and
program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
)
select
count(distinct t.signers[0]) as wallets
from
solana.core.fact_transactions t
inner join gmv2_txs g
on
t.tx_id = g.tx_id
where date(t.block_timestamp) >= '2022-07-21'