DATE_TRUNC('day', block_timestamp) AS Date,

COUNT(DISTINCT Authorizers[0]) AS Users,

COUNT(DISTINCT TX_ID) AS Txn

FROM

flow.core.fact_transactions

WHERE

block_timestamp::DATE >= '2024-01-01'

--AND Tx_succeeded = 'True'

GROUP BY 1