DATE_TRUNC('day', block_timestamp) AS Date,

COUNT(DISTINCT Authorizers[0]) AS Users,

COUNT(DISTINCT TX_ID) AS Transactions

FROM

flow.core.fact_transactions

WHERE

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

GROUP BY 1