TX_HASH | BORROWER_ADDRESS | PRINCIPAL_AMOUNT | |
|---|---|---|---|
1 | 0xbeafc040fffab95c89827a4540a71562aa2c581428684fc6db63ff30a2a7fa20 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 185929000000000000000 |
2 | 0x8f1ba4b43108487ec37c21829ddf0021ce4b19b92cc07462257ab5074d99a7dc | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 709000000000000000000 |
3 | 0x751894df24b4fd4e5196a8d6b7e23c53b1da116dbb255d52f838cbdb31148423 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 328754900000000000000 |
4 | 0xc9afba44d0e3cb11dc6c28dbe158a25249d9e30c9bcc985bda55c742cf17ae1d | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 1124700000000000000000 |
5 | 0x51b0598b6d4aa7cc207a46f0a91502faa35d8ee51996de40e07437b996d41125 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 145000000000000000000 |
6 | 0x097b497cc2a4682bb9c1aea76dd21f267ca3314c975c2085c7c213dfd867b04c | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 419800000000000000000 |
datavortexcracked
Updated 2025-03-14
999
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
›
⌄
⌄
SELECT
tx_hash,
MAX(CASE
WHEN function_name = 'isBorrower' THEN
decoded_input_data:input_1
WHEN function_name = 'borrower' THEN
decoded_output_data:output_1
END) AS borrower_address,
MAX(CASE
WHEN function_name = 'principal' THEN
decoded_output_data:output_1
END) AS principal_amount
FROM ethereum.core.ez_decoded_traces
WHERE function_name IN ('isBorrower', 'borrower', 'principal')
AND from_address = '0xe3aac29001c769fafcef0df072ca396e310ed13b'
GROUP BY tx_hash
HAVING borrower_address IS NOT NULL;
/*
SELECT
tx_hash,
MAX(CASE
WHEN function_name = 'isBorrower' THEN
decoded_input_data:input_1
WHEN function_name = 'borrower' THEN
decoded_output_data:output_1
END) AS borrower_address,
MAX(CASE
WHEN function_name = 'principal' THEN
decoded_output_data:output_1
END) AS principal_amount
FROM ethereum.core.ez_decoded_traces
WHERE function_name IN ('isBorrower', 'borrower', 'principal')
AND from_address = '0xe3aac29001c769fafcef0df072ca396e310ed13b'
GROUP BY tx_hash;
Last run: 3 months ago
6
842B
3s