date_trunc('{{Interval}}', block_timestamp) as "Date",

count(distinct tx_hash) as tx_count_daily,

(tx_count_daily / 24) as "Transaction per Hour",

("Transaction per Hour" / 60) as "Transaction per Minute",

("Transaction per Minute" / 60) as "Transaction per Second"

FROM

near.core.fact_transactions

WHERE

block_timestamp::date >= current_date - {{Transaction_History_Period_in_Days}}

AND

TX_STATUS = 'Success'

GROUP BY 1