SELECT DISTINCT event_contract AS new_contract,

MIN(trunc(block_timestamp, 'day')) AS debut

FROM flow.core.fact_events

GROUP BY 1

),

evm_news AS (

SELECT DISTINCT contract_address AS new_contract,

MIN(trunc(block_timestamp, 'day')) AS debut

FROM flow.core_evm.fact_event_logs

GROUP BY 1

),

combined_news AS (

SELECT new_contract, debut FROM news

UNION ALL

SELECT new_contract, debut FROM evm_news

),

final as (

trunc(x.block_timestamp, 'day') AS date,

COUNT(DISTINCT x.event_contract) AS active_contracts

FROM flow.core.fact_events x

WHERE x.tx_succeeded = 'true' and date<trunc(current_date,'day')

GROUP BY 1

UNION ALL

trunc(y.block_timestamp, 'day') AS date,

COUNT(DISTINCT y.contract_address) AS active_contracts

FROM flow.core_evm.fact_event_logs y where date>'2020-01-01' and date<trunc(current_date,'day')

GROUP BY 1

ORDER BY date ASC

select date, case when date<'2025-01-22' then 'Before Axelar Integration' else 'After Axelar Integration' end as period, sum(active_contracts) as active_contracts from final where date>='2025-01-01' group by 1,2 order by 1 desc