MAX_INTEREST_RATE | MIN_INTEREST_RATE | MEDIAN_INTEREST_RATE | |
|---|---|---|---|
1 | 16 | 2.75 | 5.75 |
datavortexmax min and median interest rate
Updated 2025-04-02
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
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH pre_queried_loans AS (
SELECT
TX_HASH AS tx_hash,
TRANSACTION_DATE AS transaction_date,
PRINCIPAL_AMOUNT AS principal_amount,
BORROWER_ADDRESS AS borrower_address
FROM $query('edf85916-9122-41a2-a54d-b55c74528c7c')
),
payment_breakdown AS (
SELECT
tx_hash,
MAX(decoded_output_data:"interest_"::FLOAT / POW(10, 6)) AS interest_amount
FROM ethereum.core.ez_decoded_traces
WHERE function_name = 'getPaymentBreakdown'
AND from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND tx_hash IN (
SELECT tx_hash
FROM pre_queried_loans
)
GROUP BY tx_hash
),
payment_due_dates AS (
SELECT
tx_hash,
MAX(TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER)) AS payment_due_date_timestamp
FROM ethereum.core.ez_decoded_traces
WHERE function_name = 'paymentDueDate'
AND from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND tx_hash IN (
SELECT tx_hash
FROM pre_queried_loans
)
GROUP BY tx_hash
),
Last run: about 2 months ago
1
16B
7s