AzinActive wallets during the last month
    Updated 2025-01-31

    with t1 as
    ((select
    'arbitrum' as blockchain,
    ORIGIN_FROM_ADDRESS as user,
    BLOCK_TIMESTAMP
    from
    arbitrum.core.fact_event_logs

    )

    union all

    (select
    'Avalanche' as blockchain,
    ORIGIN_FROM_ADDRESS as user,
    BLOCK_TIMESTAMP
    from
    avalanche.core.fact_event_logs

    )

    union all

    (select
    'Base' as blockchain,
    ORIGIN_FROM_ADDRESS as user,
    BLOCK_TIMESTAMP
    from
    Base.core.fact_event_logs)

    union all

    (select
    'Bsc' as blockchain,
    ORIGIN_FROM_ADDRESS as user,
    Last run: 13 days ago
    NUMBER_OF_ACTIVE_WALLETS
    BLOCKCHAIN
    1
    104785267Solana
    2
    39498825Near
    3
    16190760Base
    4
    15919742Aptos
    5
    13807333Bsc
    6
    5910291Polygon
    7
    5149203Sei
    8
    4301977Ethereum
    9
    3965033arbitrum
    10
    884317Optimism
    11
    555412Avalanche
    12
    260481Cosmos
    13
    122327Osmosis
    14
    32496Gnosis
    14
    267B
    312s