shreexıamjhuman
    Updated 2023-07-26
    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