weekly_data AS (

SELECT distinct tx_from as new_user,

min(DATE_TRUNC('week', block_timestamp::DATE)) AS week_start

FROM sei.core.fact_transactions

WHERE block_timestamp::DATE >= '2023-08-15'

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

AND tx_id NOT IN (

SELECT DISTINCT tx_id

FROM sei.core.fact_transactions

WHERE fee = '0usei'

AND block_timestamp::DATE >= '2023-08-15'

)

AND tx_succeeded = 'TRUE'

GROUP BY 1

SELECT distinct from_address as new_user,

min(DATE_TRUNC('week', block_timestamp::DATE)) AS week_start

FROM sei.core_evm.fact_transactions

GROUP BY 1

SELECT

week_start,

count(distinct new_user) as new_users,

sum(new_users) over (order by week_start) as total_users

from weekly_data where week_start < trunc(current_date,'week')

group by 1 order by 1 desc