i_danMonad: Monad VS Live Chains
    Updated 2025-02-21
    WITH all_chains AS (
    SELECT
    'Monad' AS Chain
    , COUNT(tx_hash) AS Transactions
    From monad.testnet.fact_transactions
    WHERE block_timestamp >= current_timestamp - interval '24 hours'
    GROUP BY 1
    UNION ALL
    SELECT
    'Aptos' AS Chain
    , COUNT(tx_hash) AS Transactions
    From aptos.core.fact_transactions
    WHERE block_timestamp >= current_timestamp - interval '24 hours'
    GROUP BY 1
    UNION ALL
    SELECT
    'Arbitrum' AS Chain
    , COUNT(tx_hash) AS Transactions
    From arbitrum.core.fact_transactions
    WHERE block_timestamp >= current_timestamp - interval '24 hours'
    GROUP BY 1
    UNION ALL
    SELECT
    'Avalanche' AS Chain
    , COUNT(tx_hash) AS Transactions
    From avalanche.core.fact_transactions
    WHERE block_timestamp >= current_timestamp - interval '24 hours'
    GROUP BY 1
    UNION ALL
    Last run: about 1 month ago
    Chain
    Transactions
    Chain Group
    1
    Monad3829984Monad Testnet
    2
    Aptos4130245Other
    3
    Arbitrum1813101Other
    4
    Avalanche305183Other
    5
    Base7485770Other
    6
    Bitcoin494421Other
    7
    BSC4610409Other
    8
    Ethereum1296226Other
    9
    Mantle289961Other
    10
    Near6783334Other
    11
    Optimism883230Other
    12
    Polygon3302177Other
    13
    Sei4079287Other
    13
    355B
    9s