flipside

    Never Withdraw
    Yousefi_1994Never Withdraw
    Updated 2024-12-03
    WITH DEPOSIT AS (
    SELECT
    COUNT(DISTINCT(EVENT_DATA:sender)) AS NUMBER_OF_ADDRESSES,
    FROM aptos.core.fact_events
    WHERE
    EVENT_TYPE ILIKE '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3::controller::DepositEvent%'
    AND EVENT_DATA:repay_only = false
    AND SUCCESS = TRUE
    ),

    WITHDRAW AS (

    SELECT
    COUNT(DISTINCT(EVENT_DATA:sender)) AS NUMBER_OF_ADDRESSES,
    FROM aptos.core.fact_events
    WHERE
    EVENT_TYPE ILIKE '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3::controller::WithdrawEvent%'
    AND EVENT_DATA:allow_borrow = false
    AND SUCCESS = TRUE
    )


    SELECT DEPOSIT.NUMBER_OF_ADDRESSES - WITHDRAW.NUMBER_OF_ADDRESSES FROM DEPOSIT, WITHDRAW




    QueryRunArchived: QueryRun has been archived