SELECT COUNT(DISTINCT TX_HASH) AS "Total transactions",
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Month, STATUS
FROM base.core.fact_transactions
WHERE 1=1
AND BLOCK_TIMESTAMP >= '2024-01-01' AND
BLOCK_TIMESTAMP<='2024-06-30'
GROUP BY 2, 3
ORDER BY 2 ASC