date_trunc('day', minute) as day,

max (count_txn) as TPM_MAX,

min (count_txn) as TPM_MIN,

avg (count_txn) as TPM_Average

from (

select

date_trunc('minute', block_timestamp) as minute,

count(tx_hash) as count_txn

from gnosis.core.fact_transactions

WHERE tx_hash is not null

group by 1

)

group by 1