with new_users_first_currency as (

select first_user,first_project,first_date , row_num from (

select sender as first_user ,project_name as first_project , min(block_timestamp) as first_date

, ROW_NUMBER() OVER (PARTITION BY first_user ORDER BY first_date) as row_num

from osmosis.core.fact_transfers inner join osmosis.core.dim_labels

on currency=address

group by 1,2

UNION

select TRADER as first_user ,project_name as first_project , min(block_timestamp) as first_date

, ROW_NUMBER() OVER (PARTITION BY first_user ORDER BY first_date) as row_num

from osmosis.core.fact_swaps inner join osmosis.core.dim_labels

on from_CURRENCY=address

group by 1,2

UNION

select TRADER as first_user ,project_name as first_project , min(block_timestamp) as first_date

, ROW_NUMBER() OVER (PARTITION BY first_user ORDER BY first_date) as row_num

from osmosis.core.fact_swaps inner join osmosis.core.dim_labels

on to_CURRENCY=address

group by 1,2)

where row_num=1)

select count(*) , first_project , date_trunc('week', first_date) from new_users_first_currency

group by 2 , 3