[Tech]: SubQuery requests to set up metrics for Kensetsu

[AndreyKortosov]

Problem statement

To successfully develop and grow Kensetsu, we need to set up metrics and make decisions based on the data. We have blockchain data and we need to use it to create visualizations.

In the future, we can add these metrics to Polkaswap.

Description

Metrics	Formula / Calculation	Actionable insight
Successfully opened vault	Total new opened vault per period (1 d, 7 d, 30 d, 90 d, 6 month, 1 year, All time)	Increasing vaults = growing user adoption. Stagnation = potential onboarding issues.
Successfully added collateral	Total actions successfully added collateral per period	High addition = active users. Low addition = possible process issues.
Successful repaid debt	Total actions successfully repaid debt per period	High repayment = low risk. Low repayment = potential default risk.
Successfully borrowed more	Total actions successfully borrowed more per period	High borrowing = user confidence. Low borrowing = possible lack of trust or poor market conditions.
Total collateral	Total amount of collateral all active vaults per period in $	Increasing collateral = user trust. Decreasing collateral = possible withdrawals or concerns.
Total user's debt	Total amount of borrowed all active vaults per period in $	Increasing debt = high demand. Decreasing debt = user caution or repayment trends.
Total available for users	Total amount of limits for the users all pairs per period in $	High availability = strong liquidity. Low availability = potential liquidity issues.
Bad debt	Total bad debt per period in $	Make max LTV lower, Low bad debt = healthy platform. High bad debt = financial risk, need for better risk management.

Definition of Done

We have SubQuery request:

• [ ] Successfully opened vault with adjustable period to see how many vaults were opened in the period
• [ ] Successfully added collateral with an adjustable period to see how many actions were to add collateral
• [ ] Successful repaid debt with an adjustable period to see how many actions were to repay debt
• [ ] Successful borrowed more with an adjustable period to see how many actions were to borrow more in vaults
• [ ] Total collateral with an adjustable period to see how many users collateralized money
• [ ] Total user's debt with an adjustable period to see how many users borrowed money
• [ ] Total available for users with an adjustable period to see how many limits we have for users across all pairs
• [ ] Bad debt with an adjustable period to see how much bad debt on protocol

It would be great if the result with period will be per day.

Requirements

No response