SocioCryptoSuccess rate
    Updated 2024-01-16
    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