TRANSACTION_DATE | TX_HASH | BORROWER_ADDRESS | PRINCIPAL_AMOUNT | PAYMENT_DUE_DATE | LOAN_TERM_DAYS | |
|---|---|---|---|---|---|---|
1 | 2023-08-09 00:00:00.000 | 0x8e6385c8fd8aee54abd9d5fb619063e7a9440c5b500f6923c5e5906db0abb9c9 | 0xd15b90ff80aa7e13fc69cd7ccd9fef654495e36c | 75000 | 2023-09-08 | 30 |
2 | 2023-08-09 00:00:00.000 | 0x8e6385c8fd8aee54abd9d5fb619063e7a9440c5b500f6923c5e5906db0abb9c9 | 0xee9d1874b35d40fb13e8a8e6093521f7947d5345 | 75000 | 2023-09-08 | 30 |
3 | 2023-09-07 00:00:00.000 | 0x7e5c0a70dc1bfaab6c66b872b33286b0c002ba3bb724eb2b381f71cd985375f0 | 73625 | 2023-10-07 | 30 | |
4 | 2023-09-07 00:00:00.000 | 0x7e5c0a70dc1bfaab6c66b872b33286b0c002ba3bb724eb2b381f71cd985375f0 | 0x5cf184fa4b21fb4407451de9d0cd879d9ea0d254 | 73625 | 2023-10-07 | 30 |
5 | 2023-09-12 00:00:00.000 | 0x37ba710a7dd6b2f011714022e0f6fc22e277729c9ef431b25096c3b01615e446 | 0xd15b90ff80aa7e13fc69cd7ccd9fef654495e36c | 5000000 | 2023-10-12 | 30 |
6 | 2023-09-12 00:00:00.000 | 0x37ba710a7dd6b2f011714022e0f6fc22e277729c9ef431b25096c3b01615e446 | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf | 5000000 | 2023-10-12 | 30 |
7 | 2023-09-13 00:00:00.000 | 0xb2783ec4004d6eed0414a1278b634f2eb7e8ccbc5aee6aef0b978824cac54931 | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf | 6300000 | 2023-10-13 | 30 |
8 | 2023-09-14 00:00:00.000 | 0x4d019dbd4949d4f588d37a6a773ec819f1ca46e3c77e26fa323f43579cce4437 | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf | 8000000 | 2023-10-14 | 30 |
9 | 2023-10-06 00:00:00.000 | 0x1814f8cf6d1de5ade8e1253db842986d48e733fcaf19b67d0c150a159c78d1e8 | 0x5cf184fa4b21fb4407451de9d0cd879d9ea0d254 | 72225 | 2023-11-05 | 30 |
10 | 2023-10-06 00:00:00.000 | 0x1814f8cf6d1de5ade8e1253db842986d48e733fcaf19b67d0c150a159c78d1e8 | 72225 | 2023-11-05 | 30 | |
11 | 2023-10-12 00:00:00.000 | 0x731865fb6ad7f820d12df9afd42f2b8d24e487fb3d630aafbd68b201b5a2f48e | 8000000 | 2023-11-11 | 30 | |
12 | 2023-10-27 00:00:00.000 | 0x78754dbba80e674eb113286d08eaf21e2c0f74cab327b7a714edf792ef1b68cf | 0xd15b90ff80aa7e13fc69cd7ccd9fef654495e36c | 9000000 | 2023-11-28 | 32 |
13 | 2023-10-27 00:00:00.000 | 0x78754dbba80e674eb113286d08eaf21e2c0f74cab327b7a714edf792ef1b68cf | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 | 9000000 | 2023-11-28 | 32 |
14 | 2023-11-02 00:00:00.000 | 0xab7460101ed97e55441afd795a60c9b7d531989b77688ee4d8ad9f1f7616dd5d | 9000000 | 2023-12-04 | 32 | |
15 | 2023-11-03 00:00:00.000 | 0x0bcea38f8c738969bcb2e0f23f1eaae05bc17d102a079b40cee122d495cd7eac | 0xd2df28330a879b9d80b892ba614ccae85ab742ea | 70805 | 2023-12-03 | 30 |
16 | 2023-11-03 00:00:00.000 | 0x0bcea38f8c738969bcb2e0f23f1eaae05bc17d102a079b40cee122d495cd7eac | 70805 | 2023-12-03 | 30 | |
17 | 2023-11-21 00:00:00.000 | 0x01c4ea23822f17b0c334aeb68a49b1dc2d97818debfe05fd099069de71a2c9f4 | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 | 10000000 | 2023-12-23 | 32 |
18 | 2023-11-21 00:00:00.000 | 0x01c4ea23822f17b0c334aeb68a49b1dc2d97818debfe05fd099069de71a2c9f4 | 0xd15b90ff80aa7e13fc69cd7ccd9fef654495e36c | 10000000 | 2023-12-23 | 32 |
19 | 2023-11-28 00:00:00.000 | 0xa3bba514dcd9d77220795094f5e970b0f54f4877cf56b90a60014de6c52722ef | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf | 6042000 | 2023-12-28 | 30 |
20 | 2023-11-28 00:00:00.000 | 0xa3bba514dcd9d77220795094f5e970b0f54f4877cf56b90a60014de6c52722ef | 6042000 | 2023-12-28 | 30 |
datavortexvarious-red
Updated 2025-03-20
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
›
⌄
WITH payment_due_dates AS (
SELECT
tx_hash,
MAX(decoded_output_data:paymentDueDate_::INTEGER) AS payment_due_date_unix,
MAX(TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER)) AS converted_payment_due_date,
MAX(TO_CHAR(TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER), 'YYYY-MM-DD')) AS payment_due_date,
MAX(block_timestamp) AS block_timestamp,
MAX(
DATEDIFF(
'day',
DATE_TRUNC('day', block_timestamp),
DATE_TRUNC('day', TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER))
)
) AS calculated_days
FROM ethereum.core.ez_decoded_traces
WHERE from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND function_name = 'paymentDueDate'
GROUP BY tx_hash
),
initial_loan AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS transaction_date,
tx_hash,
MAX(
CASE
WHEN function_name = 'isBorrower' THEN decoded_input_data:input_1::STRING
WHEN function_name = 'borrower' THEN decoded_output_data:output_1::STRING
END
) AS borrower_address,
MAX(
CASE
WHEN function_name = 'principal' THEN decoded_output_data:output_1::FLOAT / POW(10, 6)
END
) AS principal_amount,
Last run: 2 months ago
...
159
24KB
17s