with userbase as ( select block_timestamp, tx_signer, tx_hash

from near.core.fact_transactions

where TX_RECEIVER = 'deip-token.near')

select date_trunc('week', block_timestamp) as date, count(tx_hash) as txns, count(distinct tx_signer) as users ,

sum(users) over(order by date asc) as cum_users

from userbase

-- where BLOCK_TIMESTAMP >=

GROUP by 1

order by 1 DESC