with cw_txns as (

SELECT *

FROM sei.core.fact_transactions

WHERE tx_from NOT IN (SELECT address FROM sei.core.dim_labels)

AND tx_id NOT IN ( -- remove both evm and oracle txs by doing fee = '0usei'

SELECT DISTINCT tx_id

FROM sei.core.fact_transactions

WHERE fee = '0usei'

AND block_timestamp::DATE >= current_date - interval '{{time_frame}}'

)

AND fact_transactions_id NOT IN (

SELECT DISTINCT fact_transactions_id

FROM sei.core_evm.fact_transactions)

AND block_timestamp::DATE >= current_date - interval '{{time_frame}}'

),

cw_first_txn as (

SELECT tx_from,

min(block_timestamp) as first_txn

FROM cw_txns

GROUP BY 1

),

cw_new_users as (

SELECT date_trunc('day', first_txn) as date,

zeroifnull(count(DISTINCT tx_from)) as n_new_users

from crosschain.core.dim_dates a

LEFT JOIN cw_first_txn b

on a.date_day = date_trunc('day', b.first_txn)

GROUP by 1),

cw_active_users as (