WITH news AS (

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 (

SELECT

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

COUNT(DISTINCT x.event_contract) AS active_contracts,

'Flow' as chain

FROM flow.core.fact_events x

WHERE x.tx_succeeded = 'true' and date >= '2025-01-01'

AND date < trunc(current_date,'day')

GROUP BY 1

UNION ALL

SELECT

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

COUNT(DISTINCT y.contract_address) AS active_contracts,

'Flow EVM' as chain

FROM flow.core_evm.fact_event_logs y

WHERE date >= '2025-01-01'