MoDeFimonad tn - users chains activities hitm
    Updated 2025-03-09
    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: 11 days ago
    Date
    CHAIN
    # of Users
    Total TXs
    Average # of TXs
    1
    2015Arbitrum1164164
    2
    2015BSC113411341
    3
    2015Base13838
    4
    2015Ethereum1211211
    5
    2015Optimism188
    6
    2015Polygon12727
    7
    2016Arbitrum3310294312
    8
    2016Avalanche2615232586
    9
    2016BSC3423094679
    10
    2016Base309697323
    11
    2016Ethereum3728023757
    12
    2016Optimism277584281
    13
    2016Polygon3220205631
    14
    2017Arbitrum2157883175409
    15
    2017Avalanche1655246712149
    16
    2017BSC21671425014658
    17
    2017Base1948628012322
    18
    2017Ethereum24111384184574
    19
    2017Optimism2010517951258
    20
    2017Polygon21621212067561
    76
    2KB
    725s