select date(minute) as day, avg(n_txn_avax) as avg_txn

from (select date_trunc('minute', block_timestamp) as minute, count(distinct tx_hash) as n_txn_avax

from avalanche.core.fact_transactions

-- where STATUS='SUCCESS'

group by 1)

group by 1