select

date_trunc('{{granularity}}', block_timestamp) as date,

count(DISTINCT to_address) as contract_deployed,

sum(contract_deployed) over (order by date) as cumulative_contract_deployed

from ronin.core.fact_traces

where type ilike '%CREATE%'

and TX_SUCCEEDED

and to_address is not null

and input <> '0x'

and ORIGIN_FUNCTION_SIGNATURE <> '0x'

and block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())

group by 1

order by date desc