shreexıamjhuman
Updated 2023-07-26
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day',block_Timestamp) as date,
count(distinct signer_id) as unique_Users,
sum(unique_users) over (order by date) as cumulative_users
from
near.core.fact_actions_events
where
receiver_id = 'registry.i-am-human.near' and action_data:method_name='sbt_mint'
GROUP BY date
ORDER BY date
Run a query to Download Data