t1 as (

select

distinct tx_signer,

min(block_timestamp) as debut

from near.core.fact_transactions

where tx_succeeded = 'true'

group by 1

),

t2 as (

SELECT

distinct tx_signer,debut from t1 where debut >=CURRENT_DATE-INTERVAL '1 MONTH' and debut<current_date

)

select

trunc(debut,'day') as date,

project_name,

count(distinct tx_hash) as counts,

sum(counts) over (partition by project_name order by date) as total_counts

from near.core.fact_transactions x join near.core.dim_address_labels dal on x.tx_receiver=dal.address

join t2 on x.tx_signer=t2.tx_signer and t2.debut=x.block_timestamp

group by 1,2

order by 1 asc