select
date_trunc (day,block_timestamp) as date,
count (distinct TX_HASH) as "Transactions Per day (TPD)",
count (case when TX_STATUS = 'Fail' then 1 end) as Failed,
count (case when TX_STATUS = 'Success' then 1 end) as Success,
(Success / "Transactions Per day (TPD)") * 100 as Sucess_Rate,
count (distinct TX_SIGNER) as users,
"Transactions Per day (TPD)"/1440 as "Transactions Per Minute (TPM)",
"Transactions Per day (TPD)"/86400 as "Transactions Per Second (TPS)",
"Transactions Per day (TPD)"/users as "Transactions Per users (TPU)"
from near.core.fact_transactions
where block_timestamp >= '2022-01-01' and block_timestamp<CURRENT_DATE
group by 1