date_trunc('week', block_timestamp::date) as week,

count(distinct tx_hash) as transactions,

count(distinct tx_signer) as active_users,

sum(transactions) over (order by week) as cumulative_transactions

from near.core.fact_transactions

where tx_signer in (

select

distinct signer_id

from near.social.fact_addkey_events

where signer_id not in ('events_v1.near', 'contribut3.near', 'events_v2.near')

group by 1

having min(block_timestamp) between '{{ start_date }}' and '{{ end_date }}'

group by 1

order by 1