LTirrellUntitled Query
Updated 2022-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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