TOTAL_INTEREST_PAID | |
|---|---|
1 | 3499741.001324 |
datavortextotal interest paid
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
›
⌄
WITH pre_queried_loans AS (
SELECT
TX_HASH AS tx_hash
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
)
SELECT
SUM(COALESCE(pb.interest_amount, 0)) AS total_interest_paid
FROM pre_queried_loans pl
LEFT JOIN payment_breakdown pb
ON pl.tx_hash = pb.tx_hash;
Last run: about 1 month ago
1
18B
6s