select 'Avalanche' as chain,
block_timestamp::date as date,
count (*) as n_deployments,
from avalanche.core.fact_traces
where block_timestamp >= current_date - 30
and type in ('CREATE','CREATE2')
and tx_status = 'SUCCESS'
and output is not null
and trace_status = 'SUCCESS'
group by 1,2
order by date desc