SELECT

DISTINCT CAST(value AS VARCHAR) AS users,

MIN(date_trunc('month', b.block_timestamp)) AS debut

FROM

flow.core.ez_transaction_actors AS b,

LATERAL FLATTEN(INPUT => b.actors) AS a

GROUP BY 1

UNION ALL

SELECT

DISTINCT from_address AS users,

MIN(date_trunc('month', block_timestamp)) AS debut

FROM

flow.core_evm.fact_transactions

GROUP BY 1

),

news2 AS (

SELECT

debut,

COUNT(DISTINCT users) AS new_users

FROM

news

GROUP BY debut

),

actives AS (

SELECT

date_trunc('month', b.block_timestamp) AS month,

COUNT(DISTINCT CAST(value AS VARCHAR)) AS active_users

FROM

flow.core.ez_transaction_actors AS b,

LATERAL FLATTEN(INPUT => b.actors) AS a

GROUP BY 1

UNION ALL