TOTAL_PLATFORM_FEES_PAID | |
|---|---|
1 | 124104.460783 |
datavortextotal fees 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:"platformServiceFee_"::FLOAT / POW(10, 6)) AS platform_service_fee
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.platform_service_fee, 0)) AS total_platform_fees_paid
FROM pre_queried_loans pl
LEFT JOIN payment_breakdown pb
ON pl.tx_hash = pb.tx_hash;
Last run: about 2 months ago
1
17B
3s