flipside

    Mantle 02
    par_rnMantle 02
    Updated 2025-03-28
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(DISTINCT tx_hash) AS total_transactions,
    COUNT(DISTINCT from_address) AS unique_users,
    COUNT(DISTINCT CASE WHEN tx_succeeded THEN tx_hash END) AS successful_transactions,
    COUNT(DISTINCT CASE WHEN NOT tx_succeeded THEN tx_hash END) AS failed_transactions,
    ROUND(
    COUNT(DISTINCT CASE WHEN tx_succeeded THEN tx_hash END) * 100.0 /
    NULLIF(COUNT(DISTINCT tx_hash), 0),
    2
    ) AS success_rate_percentage,
    SUM(tx_fee) AS fees,
    AVG(tx_fee) AS average_fees
    FROM
    mantle.core.fact_transactions
    WHERE
    block_timestamp >= CURRENT_DATE - 30
    GROUP BY
    1
    ORDER BY
    1

    Last run: 14 days ago
    DATE
    TOTAL_TRANSACTIONS
    UNIQUE_USERS
    SUCCESSFUL_TRANSACTIONS
    FAILED_TRANSACTIONS
    SUCCESS_RATE_PERCENTAGE
    FEES
    AVERAGE_FEES
    1
    		2025-02-26 00:00:00.000357738715653464641127496.854262.6393656880.01191553418
    2
    		2025-02-27 00:00:00.00029863823969289753888597.023188.0527047310.01067530825
    3
    		2025-02-28 00:00:00.000312884123032947311815394.25678.3213025310.0181483275
    4
    		2025-03-01 00:00:00.00027938311637271200818397.073588.6162072220.01284479087
    5
    		2025-03-02 00:00:00.000308200113092910911710994.457557.4332222620.024521198
    6
    		2025-03-03 00:00:00.000303148120682919951115396.323985.9679740620.0131485874
    7
    		2025-03-04 00:00:00.000311040131482949781606294.844105.6692622320.01319981116
    8
    		2025-03-05 00:00:00.00029939113083290913847897.173267.3188355720.01091321661
    9
    		2025-03-06 00:00:00.00033732722239328213911497.33740.8242861060.01108960826
    10
    		2025-03-07 00:00:00.000384286230523724281185896.914415.3263833460.01148968837
    11
    		2025-03-08 00:00:00.00032206318573317050501398.442843.4956974290.008829004566
    12
    		2025-03-09 00:00:00.00033571520386329326638998.13216.5847635480.009581295931
    13
    		2025-03-10 00:00:00.000370343398443563701397396.234602.1822381940.01242681038
    14
    		2025-03-11 00:00:00.0003953936034238351611877974532.5029677480.01146328581
    15
    		2025-03-12 00:00:00.00036921539039360008920797.513419.1143345290.009260496823
    16
    		2025-03-13 00:00:00.000488251620124758851236697.475217.0535200840.01068518758
    17
    		2025-03-14 00:00:00.000479175348154679471122897.665038.4206873590.01051478205
    18
    		2025-03-15 00:00:00.000456256289144400981615896.466097.0977513810.01336332618
    19
    		2025-03-16 00:00:00.000442363284174309981136597.434202.335750150.009499745119
    20
    		2025-03-17 00:00:00.000484860400244739881087297.764990.1160424030.01029186991
    31
    3KB
    15s