superflyNEAR transactions per user-TPU NEAR transactions per second-TPS NEAR transactions per minute-TPM Daily NEAR success rate Daily NEAR transactions status Daily NEAR transactions-TP
    Updated 2022-12-14
    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


    Run a query to Download Data