select

distinct to_address as address

from monad.testnet.fact_traces

where type ilike '%CREATE%'

and TX_SUCCEEDED

and input <> '0x'

and to_address is not null

and ORIGIN_FUNCTION_SIGNATURE <> '0x'

and block_timestamp::date >= '2025-02-18'

,

total_new_contract as (

select

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

count(distinct address) as new_contract

from (

select

to_address as address,

min(block_timestamp) as first_tx

from monad.testnet.fact_transactions

where 1 = 1

and to_address IN (select address from contract_list)

group by 1

group by 1

, total_active_contract as (

select

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

count(distinct to_address) as active_contract

from monad.testnet.fact_transactions

where 1=1

and to_address IN (select address from contract_list)

and date >= '2025-02-18'

group by 1