par_rnSwell 01
    Updated 2025-02-01
    WITH daily_transactions AS (
    SELECT
    DATE(BLOCK_TIMESTAMP) AS transaction_date,
    COUNT(DISTINCT TX_HASH) AS total_transactions,
    COUNT(DISTINCT FROM_ADDRESS) AS total_users,
    SUM(TX_FEE) AS total_fees,
    AVG(TX_FEE) AS avg_tx_fee,
    COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = TRUE THEN TX_HASH END) AS successful_transactions,
    COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = FALSE THEN TX_HASH END) AS failed_transactions,
    ROUND(
    COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = TRUE THEN TX_HASH END) * 100.0
    / NULLIF(COUNT(DISTINCT TX_HASH), 0), 2
    ) AS success_rate_percentage
    FROM swell.core.fact_transactions
    GROUP BY transaction_date
    ),
    moving_averages AS (
    SELECT
    transaction_date,
    total_transactions,
    total_users,
    total_fees,
    avg_tx_fee,
    successful_transactions,
    failed_transactions,
    success_rate_percentage
    FROM daily_transactions
    )
    SELECT * FROM moving_averages
    ORDER BY transaction_date DESC

    Last run: 24 days ago
    TRANSACTION_DATE
    TOTAL_TRANSACTIONS
    TOTAL_USERS
    TOTAL_FEES
    AVG_TX_FEE
    SUCCESSFUL_TRANSACTIONS
    FAILED_TRANSACTIONS
    SUCCESS_RATE_PERCENTAGE
    1
    2025-02-01 00:00:00.000221942290.0023589869541.062894005e-7221841099.95
    2
    2025-01-31 00:00:00.000478924290.01111605842.321067902e-74778510799.78
    3
    2025-01-30 00:00:00.000484775200.01075927972.219460713e-7483898899.82
    4
    2025-01-29 00:00:00.000488915240.016270663793.327946613e-7488256699.87
    5
    2025-01-28 00:00:00.000488655450.023747689644.859856674e-7487937299.85
    6
    2025-01-27 00:00:00.000491114140.019947812964.061781059e-7490555699.89
    7
    2025-01-26 00:00:00.000475317120.0080965258531.703420053e-7474983399.93
    8
    2025-01-25 00:00:00.000476876940.0067466897431.414785947e-7476503799.92
    9
    2025-01-24 00:00:00.000489249290.014343278932.931746981e-7488873799.92
    10
    2025-01-23 00:00:00.0005040012500.035992827077.141433942e-7503287299.86
    11
    2025-01-22 00:00:00.0005457731560.029383680435.383894392e-7545096899.88
    12
    2025-01-21 00:00:00.000477702720.01534178423.21159393e-7477373399.93
    13
    2025-01-20 00:00:00.000496892270.046759679359.410468988e-7496414899.9
    14
    2025-01-19 00:00:00.000487832140.0061909044281.269070051e-7487226199.87
    15
    2025-01-18 00:00:00.000478222210.019255180614.026427295e-7477566699.86
    16
    2025-01-17 00:00:00.000470993060.02140208164.544062847e-7470584199.91
    17
    2025-01-16 00:00:00.000476042970.031944695796.710506637e-7475366899.86
    18
    2025-01-15 00:00:00.000475573170.033763087767.099499077e-7474976099.87
    19
    2025-01-14 00:00:00.000474363850.016265633393.42896395e-7473676999.85
    20
    2025-01-13 00:00:00.000484224500.032253972936.661016259e-7483675599.89
    67
    5KB
    2s