rw2023Loan events
    Updated 2025-05-25
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    CASE
    WHEN event_type IN ('terminatePerpetualLoan', 'foreclosePerpetualLoan') THEN 'ForecloseLoan'
    WHEN event_type IN ('repayStakedBanxPerpetualLoan', 'repayPartialPerpetualLoan', 'repayPerpetualLoan', 'repayCnftPerpetualLoan', 'claimCnftPerpetualLoan') THEN 'RepayLoan'
    WHEN event_type IN ('borrowPerpetual', 'borrowStakedBanxPerpetual', 'borrowCnftPerpetual') THEN 'TakeLoan'
    WHEN event_type IN ('refinancePerpetualLoan', 'borrowerRefinance', 'borrowerRefinanceToSame', 'instantRefinancePerpetualLoan', 'updatePerpetualOfferBonding') THEN 'ExtendLoan'
    END AS loan_event_category,
    COUNT(*) AS num_occurrences
    FROM
    solana.core.fact_decoded_instructions
    WHERE
    program_id = '4tdmkuY6EStxbS6Y8s5ueznL3VPMSugrvQuDeAHGZhSt'
    AND block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'
    AND event_type IN (
    'terminatePerpetualLoan', 'foreclosePerpetualLoan',
    'repayStakedBanxPerpetualLoan', 'repayPartialPerpetualLoan', 'repayPerpetualLoan', 'repayCnftPerpetualLoan', 'claimCnftPerpetualLoan',
    'borrowPerpetual', 'borrowStakedBanxPerpetual', 'borrowCnftPerpetual',
    'refinancePerpetualLoan', 'borrowerRefinance', 'borrowerRefinanceToSame', 'instantRefinancePerpetualLoan', 'updatePerpetualOfferBonding'
    )
    GROUP BY
    DATE_TRUNC('day', block_timestamp),
    loan_event_category
    ORDER BY
    date DESC,
    num_occurrences DESC;
    Last run: about 1 month ago
    No Data to Display
    0
    2B
    1s