select

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

'Core' as chain,

count(DISTINCT tx_hash) as contract_deployed,

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

from core.core.fact_traces

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

and date < current_date

and type ilike 'CREATE%'

group by 1

order by date desc