AzinActive wallets during the last 3 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
    332062239Solana
    2
    63905742Near
    3
    46761144Base
    4
    27668696Bsc
    5
    25664148Aptos
    6
    14578342Polygon
    7
    10394103Sei
    8
    9881915Ethereum
    9
    7335766arbitrum
    10
    2011647Optimism
    11
    1134289Avalanche
    12
    683193Cosmos
    13
    285210Osmosis
    14
    68980Gnosis
    14
    271B
    867s