flipside

    Try Quests to earn cryptoTry Quests to earn crypto
    10Blockchain
    discord@10Blockchain

    Mantle L2 Post-Tectonic: Data Gaps and DA Externalization

    hexagon

    Flipside AI

    Mantle's Layer-2 blockchain experienced remarkable growth and volatility, with daily transactions peaking at 2.20 million and batch transactions reaching a high of 12,858 tx/batch in mid-March 2024. However, the network showed significant instability, with daily L1 batch counts hitting 475 in August 2023 before experiencing a gradual decline and eventual complete cessation of on-chain batch commits, signaling potential operational challenges in the Layer-2 ecosystem.

    This dashboard illustrates how Mantle’s Tectonic upgrade (v2)—which shifts data availability to EigenDA—changes on-chain batch logging after mid-March 2024. We present three charts (Daily L2 Transactions, Daily L1 Batches, and the L2 Tx/Batch Ratio) to show how L2 transactions remain robust, yet the Flipside pipeline returns ‘null’ for batch counts post-upgrade due to no commitments posted on Ethereum. Our aim is to clarify these gaps and help deliver a more complete view of Mantle’s post-upgrade activity.

    Methodology & Data Sources
    • L2 Transactions
      • Source: mantle.core.fact_transactions
      • Filtering: Use WHERE clauses to include only valid L2 transactions
      • Aggregation:
        • DATE_TRUNC('day', block_timestamp)
        • GROUP BY DATE_TRUNC('day', block_timestamp) for daily counts
    • L1 Batch Entries
      • Source: ethereum.core.fact_transactions, filtered by Mantle batch contract addresses
        • WHERE to_address IN ('0x...CTC', '0x...SCC')
      • Aggregation:
        • DATE_TRUNC('day', block_timestamp)
        • GROUP BY DATE_TRUNC('day', block_timestamp) to get daily_l1_batch_count
    • Joins / Merging
      • Use LEFT JOIN or FULL OUTER JOIN on day to combine L2 and L1 data
      • Use COALESCE or CASE WHEN to handle null values (missing data after the upgrade)
      • CASE WHEN daily_l1_batch_count IS NULL THEN 0 ELSE daily_l1_batch_count END to convert null to zero
    • Tx/Batch Ratio
      • Calculate as (daily_l2_tx_count * 1.0) / daily_l1_batch_count
      • Nulls: Appear after mid-March 2024 because Mantle v2 Tectonic (EigenDA) no longer posts batch logs on Ethereum
    Disclaimer: Flipside AI is here to help but it can make mistakes. Always review outputs and use the upvote/downvote buttons to help us improve. This content is not financial advice.