Abbas_ra21Total Users daily
    Updated 2025-02-03
    -- forked from Total Users daily @ https://flipsidecrypto.xyz/edit/queries/fddfdd86-d49c-45a0-8447-f34a4a7054b2

    -- forked from Total Users @ https://flipsidecrypto.xyz/edit/queries/3352b4a6-ce17-43aa-84ce-ef11460a2cb4
    with main AS (select
    BLOCK_TIMESTAMP,
    'Deposit' AS "Event Name",
    DEPOSITOR AS user
    from
    base.defi.ez_lending_deposits
    where
    PLATFORM = 'Moonwell'
    union ALL
    select
    BLOCK_TIMESTAMP,
    'Borrow' AS "Event Name",
    BORROWER AS user
    from
    base.defi.ez_lending_borrows
    where
    PLATFORM = 'Moonwell'
    union ALL
    select
    BLOCK_TIMESTAMP,
    'Flashloan' AS "Event Name",
    INITIATOR AS user
    from
    base.defi.ez_lending_flashloans
    where
    PLATFORM = 'Moonwell'
    union ALL
    select
    BLOCK_TIMESTAMP,
    'Liquidation' AS "Event Name",
    BORROWER AS user
    from
    base.defi.ez_lending_liquidations
    Last run: 25 days ago
    WEEK
    Retained Users
    New Users
    Total Users
    1
    2024-07-22 00:00:00.00056123364175556
    2
    2024-08-26 00:00:00.00045713287188647
    3
    2023-09-04 00:00:00.0001303631180
    4
    2024-08-12 00:00:00.00036942619182627
    5
    2023-10-16 00:00:00.00025521836919
    6
    2023-11-20 00:00:00.000389154912775
    7
    2024-11-18 00:00:00.00062382205222747
    8
    2023-12-11 00:00:00.000726104915800
    9
    2024-07-01 00:00:00.00062084270163672
    10
    2023-08-21 00:00:00.00072143445
    11
    2025-01-13 00:00:00.00069191442238895
    12
    2024-07-15 00:00:00.00054153874172192
    13
    2024-04-29 00:00:00.0004278551794762
    14
    2024-12-23 00:00:00.00066993079234267
    15
    2024-04-15 00:00:00.0003022822281570
    16
    2023-11-06 00:00:00.00046776110185
    17
    2024-06-17 00:00:00.00058114210155470
    18
    2023-09-11 00:00:00.0001402961476
    19
    2024-09-16 00:00:00.00053253347198688
    20
    2024-05-27 00:00:00.000575012944138047
    79
    3KB
    4s