SELECT

date,

num_of_txns / NULLIF(DATEDIFF(second, min_block_timestamp, max_block_timestamp), 0) as T_P_S

FROM (

SELECT

date_trunc('day', block_timestamp) as date,

count(DISTINCT tx_hash) as num_of_txns,

min(block_timestamp) as min_block_timestamp,

max(block_timestamp) as max_block_timestamp

FROM mezo.testnet.fact_transactions

GROUP BY 1

ORDER BY date DESC;