mattkstewNEAR Horizon 2
    Updated 2023-06-24
    select
    date_trunc('week', block_timestamp) as Date_week,
    count(distinct SIGNER_ID) as Total_Users,
    count_if(method_name like 'add_project') as Total_Projects

    from near.horizon.fact_decoded_actions
    group by 1
    Run a query to Download Data