date(block_timestamp) as date,

type,

count(tx_hash) as no_contracts

from base.core.fact_traces

where type in ('CREATE', 'CREATE2')

and tx_status = 'SUCCESS'

group by 1,2

having date >= '2023-07-10'