MoDeFimonad tn - Testnet Users On Top 7 Chains
    Updated 8 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: 8 days ago
    CHAIN
    Chain Users
    Other Users
    Total TXs
    Average # of TXs
    1
    Arbitrum12257192242429819455767877
    2
    Avalanche3863862250823141940110750
    3
    BSC1083092224385608139615887129
    4
    Base135289822411580212023129089
    5
    Ethereum12367112242319894800456539
    6
    Optimism9915772244771235697282457
    7
    Polygon1048563224420137157394417150
    7
    296B
    840s