MoDeFimonad tn - users chains activities history
    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
    # of Users
    Average # of TXs
    Average # of Chains
    1
    2015-01-01 00:00:00.000117896
    2
    2016-01-01 00:00:00.0003730856
    3
    2017-01-01 00:00:00.000241126126
    4
    2018-01-01 00:00:00.000789915736
    5
    2019-01-01 00:00:00.000529113865
    6
    2020-01-01 00:00:00.0001251225226
    7
    2021-01-01 00:00:00.0009241417016
    8
    2022-01-01 00:00:00.0001585467455
    9
    2023-01-01 00:00:00.0003704163495
    10
    2024-01-01 00:00:00.0005666161343
    11
    2025-01-01 00:00:00.000509499181
    11
    441B
    709s