count(DISTINCT tx_id) as transactions,

sum(transactions) over (order by daily) as cumulative_txns,

count(DISTINCT authorizers) as users,

count(DISTINCT block_timestamp::date) as days,

transactions/users as "Avg txn per User"

from flow.core.fact_transactions

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

group by 1