select avg(n_txn_avax)

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'

where datediff('day',block_timestamp,getdate())<=14

group by 1)