DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS Date

, COUNT(*) AS TX_number

, COUNT(DISTINCT TX_SENDER) AS Active_users

, COUNT(CASE WHEN TX_SUCCEEDED='TRUE' THEN 1 ELSE NULL END ) * 100 / TX_number AS Success_rate

, SUM(TX_number) OVER (ORDER BY DATE) AS "Total transactions"

terra.core.fact_transactions

WHERE

BLOCK_TIMESTAMP IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC