SELECT date(first_use) as day, count(DISTINCT tx_signer) as total_signers,
sum(total_signers) over (order by day) as cum_signers
from
(SELECT tx_signer, min(block_timestamp) as first_use
from near.core.fact_transactions
where tx_receiver = 'v2.ref-finance.near'
and tx_status ilike 'success'
GROUP by 1 )
where day >= CURRENT_DATE - {{n_last_days}}
GROUP by 1