strawbettyfailed transaction rate for Terra
    Updated 2022-03-27
    with terra_txns as (
    SELECT
    COUNT(CASE WHEN tx_status='SUCCEEDED' THEN tx_id ELSE NULL END) as stotals,
    COUNT(CASE WHEN tx_status!='SUCCEEDED' THEN tx_id ELSE NULL END) as ftotals,
    COUNT(tx_id) as totals,
    date_trunc('day', block_timestamp) as ddate
    from terra.transactions
    WHERE
    block_timestamp>='2022-01-01'
    GROUP BY ddate ORDER BY ddate ASC
    )

    SELECT
    ddate,
    (ftotals/totals)*100 as failure_rate,
    stotals as successful_txns,
    ftotals as failed_txns
    from terra_txns
    Run a query to Download Data