Zanyar_98Daily Users and New Users
    Updated 4 hours ago
    ------------------------------------------------------------------------------ Core Market ------------------------------------------------------------------------------

    --------------------------------------- Initialized Pools ---------------------------------------

    WITH COLEND_CORE_MARKETS_INITIALIZED_POOL_ON_COLEND AS (
    SELECT
    CONTRACT_ADDRESS AS POOL_ADDRESS,
    (DECODED_LOG:underlyingAsset)::STRING AS ASSET_ADDRESS
    FROM
    core.core.ez_decoded_event_logs
    WHERE
    TOPIC_0 = '0xb19e051f8af41150ccccb3fc2c2d8d15f4a4cf434f32a559ba75fe73d6eea20b'
    AND EVENT_NAME = 'Initialized'
    AND DECODED_LOG:pool = '0x0cea9f0f49f30d376390e480ba32f903b43b19c5'
    AND DECODED_LOG:underlyingAsset != '0x0000000000000000000000000000000000000000'
    AND TX_SUCCEEDED = TRUE
    ),
    COLEND_CORE_MARKETS_INITIALIZED_DEPT_POOL_ON_COLEND AS (
    SELECT
    CONTRACT_ADDRESS AS POOL_ADDRESS,
    (DECODED_LOG:underlyingAsset)::STRING AS ASSET_ADDRESS
    FROM
    core.core.ez_decoded_event_logs
    WHERE
    EVENT_NAME = 'Initialized'
    AND DECODED_LOG:pool = '0x0cea9f0f49f30d376390e480ba32f903b43b19c5'
    AND DECODED_LOG:underlyingAsset != '0x0000000000000000000000000000000000000000'
    AND TX_SUCCEEDED = TRUE
    AND CONTRACT_NAME ILIKE '%Debt%'
    ),

    --------------------------------------- Deposit ---------------------------------------

    COLEND_CORE_MARKETS_DEPOSIT_ASSETS AS (
    SELECT
    Last run: about 4 hours agoAuto-refreshes every 24 hours
    Date
    User Type
    Number of Users
    1
    2024-11-05 00:00:00.000New Users13
    2
    2025-05-04 00:00:00.000Daily Users114
    3
    2024-08-06 00:00:00.000Daily Users121
    4
    2024-10-20 00:00:00.000Daily Users87
    5
    2025-01-10 00:00:00.000Daily Users141
    6
    2025-03-11 00:00:00.000Daily Users118
    7
    2024-06-23 00:00:00.000Daily Users34
    8
    2024-08-12 00:00:00.000Daily Users91
    9
    2024-11-17 00:00:00.000Daily Users133
    10
    2025-06-11 00:00:00.000Daily Users119
    11
    2024-12-05 00:00:00.000Daily Users142
    12
    2025-04-03 00:00:00.000Daily Users86
    13
    2025-01-12 00:00:00.000Daily Users101
    14
    2024-09-11 00:00:00.000Daily Users136
    15
    2024-09-17 00:00:00.000New Users54
    16
    2025-03-18 00:00:00.000Daily Users117
    17
    2024-11-09 00:00:00.000Daily Users122
    18
    2025-05-11 00:00:00.000Daily Users106
    19
    2025-06-02 00:00:00.000Daily Users146
    20
    2024-09-03 00:00:00.000New Users105
    ...
    887
    38KB
    94s