WITH

transfers as (

SELECT

distinct from_address as users,

min(trunc(block_timestamp,'week')) as weeks

from base.core.fact_token_transfers

group by 1

),

swaps as (

SELECT

distinct ORIGIN_FROM_ADDRESS as users,

min(trunc(block_timestamp,'week')) as weeks

from base.defi.ez_dex_swaps

group by 1

),

nft as (

SELECT

distinct ORIGIN_FROM_ADDRESS as users,

min(trunc(block_timestamp,'week')) as weeks

from base.core.fact_event_logs

join base.core.dim_labels on contract_address=address

where label_type='nft'

group by 1

),

news as (

select

trunc(weeks,'week') as date,

'Transferers' as type,

count(distinct users) as new_users,

sum(new_users) over (order by date) as "Total unique users"

from transfers

group by 1,2

select