SELECT
Date_trunc('day', Block_timestamp) date,
COUNT(DISTINCT TX_ID) AS Total_Transactions,
COUNT(DISTINCT Authorizers[0]) AS Total_Users
FROM flow.core.fact_transactions
WHERE
DATE_PART('quarter', block_timestamp) = 1
AND
DATE_PART('year', block_timestamp) = 2024
AND
Tx_succeeded = 'True'
GROUP BY
1