No Data to Display
rw2023Loan events
Updated 2025-05-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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
0
2B
1s