princefarzamThe number of transactions in terms of status since Sep 2021
    Updated 2022-07-20
    SELECT
    DATE_TRUNC('DAY',block_timestamp)::DATE AS DAY,
    COUNT(TXN_HASH) AS NUMBER_OF_TRANSACTIONS,
    substr(tx_receipt[0]:outcome:status,3,7)::string AS Status
    FROM flipside_prod_db.mdao_near.transactions
    GROUP BY DAY,Status
    ORDER BY DAY ASC

    Run a query to Download Data