DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,

COUNT(DISTINCT SIGNER_ID) AS number_of_distinct_users,

COUNT(*) AS number_of_transactions

FROM

near.horizon.fact_decoded_actions

GROUP BY

DATE_TRUNC('week', BLOCK_TIMESTAMP)

ORDER BY

week;