MoDeFimonad tn - Testnet Users On Top 7 Chains
    Updated 7 days ago
    with address_array as (
    select distinct FROM_ADDRESS as address
    from monad.testnet.fact_transactions),

    wallets_txs as
    (select FROM_ADDRESS as wallet, 'Polygon' as chain, tx_hash, BLOCK_TIMESTAMP
    from polygon.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    select FROM_ADDRESS, 'Optimism' as chain, tx_hash, BLOCK_TIMESTAMP
    from optimism.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    select FROM_ADDRESS, 'Arbitrum', tx_hash, BLOCK_TIMESTAMP
    from arbitrum.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    select FROM_ADDRESS, 'Ethereum', tx_hash, BLOCK_TIMESTAMP
    from ethereum.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    select FROM_ADDRESS, 'Avalanche', tx_hash, BLOCK_TIMESTAMP
    from avalanche.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    select FROM_ADDRESS, 'BSC', tx_hash, BLOCK_TIMESTAMP
    from bsc.core.fact_transactions
    where FROM_ADDRESS in (select address from address_array)
    union all
    -- select FROM_ADDRESS, 'Gnosis', tx_hash, BLOCK_TIMESTAMP
    -- from gnosis.core.fact_transactions
    -- where FROM_ADDRESS in (select address from address_array)
    -- union all
    -- select FROM_ADDRESS, 'Aurora', tx_hash, BLOCK_TIMESTAMP
    -- from aurora.core.fact_transactions
    -- where FROM_ADDRESS in (select address from address_array)
    Last run: 7 days ago
    CHAIN
    Chain Users
    Other Users
    Total TXs
    Average # of TXs
    1
    Arbitrum13793053038571709957261972
    2
    Avalanche4766893047597862132826845
    3
    BSC1225408304011067145977862119
    4
    Base152313030371334514593726796
    5
    Ethereum13506383038858375095405138
    6
    Optimism11037743041327016240905857
    7
    Polygon1117607304118868165821040148
    7
    297B
    389s