date,

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

FROM (

SELECT

date_trunc('{{granularity}}', 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 aptos.core.fact_transactions

GROUP BY 1

WHERE date >= dateadd(day, -{{past_days}}, current_date())