select

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

'Base' as chain,

count(DISTINCT tx_hash) as contract_deployed

from base.core.fact_traces

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

and date < current_date

and type ilike 'CREATE%'

group by 1

, avalanche_ as (

select

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

'Avalanche' as chain,

count(DISTINCT tx_hash) as contract_deployed

from avalanche.core.fact_traces

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

and date < current_date

and type ilike 'CREATE%'

group by 1

select *

from base_

union all

select *

from avalanche_