MoDeFimonad tn - users chains activities history
    Updated 5 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: 5 days ago
    Date
    # of Users
    Average # of TXs
    Average # of Chains
    1
    2015-01-01 00:00:00.000217575
    2
    2016-01-01 00:00:00.0004329916
    3
    2017-01-01 00:00:00.000263825936
    4
    2018-01-01 00:00:00.000158078444
    5
    2019-01-01 00:00:00.00091338744
    6
    2020-01-01 00:00:00.0001350325086
    7
    2021-01-01 00:00:00.00010191316736
    8
    2022-01-01 00:00:00.0001801017285
    9
    2023-01-01 00:00:00.0004420813465
    10
    2024-01-01 00:00:00.0006709981443
    11
    2025-01-01 00:00:00.000843422272
    11
    441B
    841s