COUNT(DISTINCT contract_id) AS total_contracts_deployed

FROM stellar.core.fact_operations

WHERE

soroban_operation_type = 'create_contract'

-- AND closed_at >= DATEADD('day', -30, CURRENT_TIMESTAMP);