*,

sum(new_users) over (ORDER by day) AS total_users

FROM (

SELECT

day,

count(*) as new_users

FROM (

SELECT

signer_id,

min(date_trunc('day', block_timestamp)) as day

FROM

near.core.fact_actions_events

WHERE receiver_id = 'registry.i-am-human.near'

AND action_data:method_name = 'sbt_mint'

GROUP BY 1

ORDER BY 2 DESC

)

GROUP by 1

ORDER BY day DESC