website

twitter

github

Lending

Prime Numbers

# Prime Numbers Active loans Methodology

## 1. Overview

Active loans represents the total outstanding loan balance in the PrimeNumbers lending protocol, measured in USD. This metric tracks the cumulative amount of tokens borrowed but not yet repaid across all lending markets. It answers the business question "How much total debt is currently outstanding in the protocol?" The calculation aggregates daily borrow and repay flows to maintain running balances of active loans by token, then converts to USD for reporting.

## 2. Data sources

- **XDC blockchain events**: Parsed `Borrow` and `Repay` events from the PrimeNumbers LendingPool contract on XDC chain
- **Token metadata**: Token decimal information for proper unit conversion
- **End-of-day price feeds**: Token prices in USD for value conversion, with special mapping for psXDC tokens using WXDC prices
- **Protocol configuration**: Chain availability filters and protocol-specific business logic

## 3. Step-by-step calculation

### Component A: Event extraction
- **Purpose**: Extract raw lending activity from blockchain events
- **Logic**: Parse `Borrow` events from XDC blockchain LendingPool contract to capture new loan originations, including fields like reserve token, user address, borrower, amount, and borrow rate. Similarly extract `Repay` events to capture loan payments including reserve token, user address, repayer, and repayment amount. All events are filtered to PrimeNumbers v1 protocol data with incremental processing for efficiency.
- **Key fields**: `token_address` (reserve token), `user_address` (borrower), `amount` (loan/repayment amount), `borrow_rate`, `block_timestamp`

### Component B: Daily flow aggregation
- **Purpose**: Convert individual transactions into daily net loan flows
- **Logic**: Combine borrow and repay events by day, treating borrows as positive flows and repays as negative flows (subtracting repayments from new loans). Aggregate all flows by day, chain, product, and token address to get net daily loan activity per token. This creates a time series of daily changes in loan balances.
- **Key fields**: `timestamp` (daily), `chain` (XDC), `product_id` (PrimeFi Lending), `token_address`, `amount` (net daily flow)

### Component C: Cumulative balance calculation
- **Purpose**: Calculate running balances of active loans over time
- **Logic**: Apply window function with cumulative sum over daily flows, partitioned by chain, product, and token address, ordered by timestamp. This transforms daily changes into running totals representing the outstanding loan balance for each token on each day. Apply decimal correction using token metadata to ensure proper unit representation.
- **Key fields**: `active_loans` (cumulative balance), `token_symbol`, corrected decimal values

### Component D: Delta calculation
- **Purpose**: Calculate day-over-day changes in active loan balances
- **Logic**: Use lag window function to compare current day balance with previous day balance for the same token. Calculate delta as current balance minus previous balance (or zero if no previous balance exists). This creates daily change values that can be aggregated and forward-filled for missing days.
- **Key fields**: `delta_active_loans` (daily change), `lending_pool_address`, `lending_market_address`

### Final aggregation
- **Combining components**: Sum delta active loans by day, chain, product, and token address to handle any duplicate records or multiple lending markets
- **Currency conversion**: Convert token amounts to USD using end-of-day price feeds, with special mapping logic where psXDC token addresses are mapped to WXDC addresses for price lookup while preserving original token identity
- **Time aggregation**: Apply forward-filling strategy to handle missing days in the time series, ensuring continuous data coverage across the entire protocol lifetime
- **Final calculation**: Calculate cumulative active loans using window function sum over deltas, partitioned by chain, product, and token, ordered by timestamp. Apply chain availability filters to ensure data is only reported for time periods when the protocol was actually active and being monitored.

*This methodology was automatically generated by Token Terminal's methodology analyzer.*

Value of loans currently outstanding to borrowers.

Prime NumbersPRFI

Active loans

Active loans

Competitive landscape

Chain breakdown