select

block_timestamp,

FROM_ADDRESS as user

from blast.core.fact_transactions a

left outer join blast.core.dim_labels b on a.TO_ADDRESS = b.address

where FROM_ADDRESS not in (

select address from blast.core.dim_labels

and STATUS = 'SUCCESS'

UNION all

select

block_timestamp,

TO_ADDRESS as user

from blast.core.fact_transactions a

left outer join blast.core.dim_labels b on a.TO_ADDRESS = b.address

where TO_ADDRESS not in (select address from blast.core.dim_labels)

and STATUS = 'SUCCESS'

,

new_user as (

select min(block_timestamp) as min_date,

user

from new

group by 2

select trunc(min_date,'d') as weekly,

count(DISTINCT user) as "New Users",

sum("New Users") over (order by weekly asc) as "Cumulative New Users"

from new_user

where min_date::date >= '2024-02-29'

group by 1