WITH news AS (

SELECT

DISTINCT CAST(value AS VARCHAR) AS users,

MIN(trunc(b.block_timestamp, 'day')) 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(trunc(block_timestamp, 'day')) 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

trunc(b.block_timestamp, 'day') AS week,

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