Mrftiusual-gray copy
    Updated 11 hours ago
    -- forked from usual-gray @ https://flipsidecrypto.xyz/studio/queries/a355005e-1744-446f-8ee8-22a495f68510

    WITH daily_tx AS
    (
    SELECT
    date_trunc('day', block_timestamp) as day,
    count(DISTINCT tx_hash) as "Total Transactions"
    FROM swell.core.fact_transactions
    GROUP BY day
    ),
    daily_succeeded_tx AS
    (
    SELECT
    date_trunc('day', block_timestamp) as day,
    count(DISTINCT tx_hash) as "Total Succeeded Transactions"
    FROM swell.core.fact_transactions
    WHERE TX_SUCCEEDED = 'TRUE'
    GROUP BY day
    )

    SELECT
    a.day,
    b."Total Succeeded Transactions" / a."Total Transactions" * 100 as "tx Success Rate %"
    FROM daily_tx a
    JOIN daily_succeeded_tx b
    ON a.day = b.day
    ORDER BY 1


    Last run: about 11 hours agoAuto-refreshes every 12 hours
    DAY
    tx Success Rate %
    1
    2024-11-27 00:00:00.000100
    2
    2024-11-28 00:00:00.000100
    3
    2024-11-29 00:00:00.000100
    4
    2024-11-30 00:00:00.000100
    5
    2024-12-01 00:00:00.000100
    6
    2024-12-02 00:00:00.000100
    7
    2024-12-03 00:00:00.00099.9219
    8
    2024-12-04 00:00:00.00099.9934
    9
    2024-12-05 00:00:00.000100
    10
    2024-12-06 00:00:00.00099.9978
    11
    2024-12-07 00:00:00.00099.9955
    12
    2024-12-08 00:00:00.000100
    13
    2024-12-09 00:00:00.00099.9978
    14
    2024-12-10 00:00:00.00099.9912
    15
    2024-12-11 00:00:00.00099.9101
    16
    2024-12-12 00:00:00.00099.9912
    17
    2024-12-13 00:00:00.00099.9934
    18
    2024-12-14 00:00:00.00099.9823
    19
    2024-12-15 00:00:00.00099.9889
    20
    2024-12-16 00:00:00.00099.9824
    ...
    110
    4KB
    53s