SocioCryptoSuccess rate
Updated 2024-01-16
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date_trunc('day', block_timestamp) as hours,
sum(CASE WHEN tx_succeeded = 'TRUE' THEN 1 ELSE 0 END) as successful_txns,
sum(CASE WHEN tx_succeeded != 'TRUE' THEN 1 ELSE 0 END) as unsuccessful_txns,
100*successful_txns/(successful_txns+unsuccessful_txns) as success_rate
FROM terra.core.fact_transactions
WHERE hours <= CURRENT_DATE-1
GROUP by hours
ORDER BY hours DESC
QueryRunArchived: QueryRun has been archived