DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS Date

, COUNT(*) AS TX_number

, COUNT(DISTINCT tx_id ) AS TX_number_sa

, 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"

, SUM(TX_number_sa) OVER (ORDER BY DATE) AS "Total transactions_sa"

terra.core.fact_transactions

WHERE

BLOCK_TIMESTAMP IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC

TX_SUCCEEDED=true