princefarzamThe performance of NEAR protocol since Sep 2021
    Updated 2022-07-20
    WITH TPM AS (
    SELECT
    DATE_TRUNC('DAY',block_timestamp)::DATE AS DAY,
    COUNT(TXN_HASH) AS NUMBER_OF_TRANSACTIONS,
    NUMBER_OF_TRANSACTIONS/1440 AS TRANSACTIONS_PER_MINUTE
    FROM flipside_prod_db.mdao_near.transactions
    WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Success'
    GROUP BY DAY
    ORDER BY DAY ASC
    )

    SELECT
    (SELECT
    COUNT(DISTINCT TXN_HASH) as Number_of_all_txns
    FROM flipside_prod_db.mdao_near.transactions) AS Number_of_all_txns,
    (SELECT
    COUNT(substr(tx_receipt[0]:outcome:status,3,7)) as Number_of_success_txns
    FROM flipside_prod_db.mdao_near.transactions
    WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Success') AS Number_of_success_txns,
    (SELECT
    COUNT(substr(tx_receipt[0]:outcome:status,3,7)) as Number_of_fail_txns
    FROM flipside_prod_db.mdao_near.transactions
    WHERE substr(tx_receipt[0]:outcome:status,3,7)::string='Failure') AS Number_of_fail_txns,
    (Number_of_success_txns/Number_of_all_txns)*100 AS Percentage_of_success_txns,
    (Number_of_fail_txns/Number_of_all_txns)*100 AS Percentage_of_fail_txns,
    AVG(NUMBER_OF_TRANSACTIONS) AS Average_Daily_txns,
    AVG(TRANSACTIONS_PER_MINUTE) AS Average_TPM
    FROM TPM
    Run a query to Download Data