(SELECT

MIN(BLOCK_TIMESTAMP) AS MDATE

, TX_SENDER

FROM

terra.core.fact_transactions

WHERE

BLOCK_TIMESTAMP IS NOT NULL

GROUP BY 2)

SELECT

DATE_TRUNC('WEEK' , MDATE) AS Date

, COUNT(*) AS "New users"

, SUM("New users") OVER (ORDER BY DATE) AS "Total users"

FROM

T1

GROUP BY 1

ORDER BY 1 DESC