select date_trunc('day', block_timestamp) as date,
COUNT(DISTINCT tx_id) as tx_count,
COUNT(DISTINCT signers[0]) as wallets
from solana.core.fact_transactions
where instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and succeeded = TRUE
and date >= CURRENT_DATE - 30
group by date