date_trunc('day', block_timestamp) as day,

count(*) as transactions,

COUNT(DISTINCT PROPOSER) as active_users

FROM flow.core.fact_transactions

GROUP BY 1