LTirrellUntitled Query
    Updated 2022-05-02
    select
    date_trunc('day', block_timestamp) as datetime,
    count(tx_id) as transactions,
    count(iff(tx_status = 'SUCCEEDED', 1, NULL)) as succeeded_transactions,
    transactions /(3600 * 24) as tps_with_fails,
    succeeded_transactions /(3600 * 24) as tps,
    succeeded_transactions / transactions as success_rate
    from
    terra.transactions
    group by
    datetime
    order by
    datetime
    Run a query to Download Data