DATE_TRUNC('week', FACT_TRANSACTIONS.BLOCK_TIMESTAMP) AS WEEK,

REGEXP_SUBSTR(ADDRESS_NAME, '^[^[:space:]:]+') AS cex,

COUNT(DISTINCT FACT_TRANSACTIONS.FROM_ADDRESS) AS NUM_CEX_USERS

FROM AVALANCHE.CORE.FACT_TRANSACTIONS FACT_TRANSACTIONS

JOIN AVALANCHE.CORE.DIM_LABELS DIM_LABELS

ON FACT_TRANSACTIONS.FROM_ADDRESS = DIM_LABELS.ADDRESS

WHERE DIM_LABELS.LABEL_TYPE = 'cex'

AND FACT_TRANSACTIONS.BLOCK_TIMESTAMP >= DATEADD('month', -12, CURRENT_DATE())

GROUP BY 1, 2

ORDER BY 1, 2;