WITH tb AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS date,
PAYER AS user,
TX_ID
FROM flow.core.fact_transactions
WHERE DATE_TRUNC('YEAR', BLOCK_TIMESTAMP) >= '2023-01-01'
)
SELECT
date,
COUNT(DISTINCT user) AS new_users,
COUNT(TX_ID) AS transactions_per_day
FROM tb
GROUP BY date
ORDER BY date;