block_timestamp::date as date,

count(TX_HASH) as "Number of Total Txs",

count(case when tx_STATUS = 'Success' then TX_HASH end) as "Number of Successful Txs",

("Number of Successful Txs" / "Number of Total Txs")*100 as "Successful Txs Rate",

(100 - "Successful Txs Rate") as "Failed Txs Rate",

count(case when tx_STATUS = 'Success' then TX_HASH end) / (24) as "Successful Transactions per Hour",

count(case when tx_STATUS = 'Success' then TX_HASH end) / (24*60) as "Successful Transactions per Minute",

count(case when tx_STATUS = 'Success' then TX_HASH end) / (24*60*60) as "Successful Transaction per Second"

from near.core.fact_transactions

group by 1

ORDER BY 1