crypto_gostshivering-copper
    Updated 2025-01-10
    SELECT
    SUM(successful_transactions) AS total_successful_transactions,
    SUM(failed_transactions) AS total_failed_transactions,
    SUM(successful_transactions) * 100.0 / NULLIF(SUM(successful_transactions) + SUM(failed_transactions), 0) AS overall_success_percentage,
    SUM(failed_transactions) * 100.0 / NULLIF(SUM(successful_transactions) + SUM(failed_transactions), 0) AS overall_failure_percentage
    FROM (
    SELECT
    COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END) AS successful_transactions,
    COUNT(CASE WHEN tx_succeeded = FALSE THEN 1 END) AS failed_transactions
    FROM
    ALEO.core.fact_transactions
    WHERE
    block_timestamp >= DATEADD(DAY, -30, GETDATE())
    ) AS daily_totals;
    Last run: about 2 months ago
    TOTAL_SUCCESSFUL_TRANSACTIONS
    TOTAL_FAILED_TRANSACTIONS
    OVERALL_SUCCESS_PERCENTAGE
    OVERALL_FAILURE_PERCENTAGE
    1
    33763103777298.8936411.106359
    1
    36B
    2s