ORIGIN_FROM_ADDRESS | CONTRACT_ADDRESS | BORROWER_ADDRESS | PRINCIPAL | INTEREST | COLLATERAL | BLOCK_TIMESTAMP | TX_HASH | |
|---|---|---|---|---|---|---|---|---|
1 | 0x3dcfedb9bbee33a21fb7a7ed466192d4c6834c77 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x3dcfedb9bbee33a21fb7a7ed466192d4c6834c77 | 3999995450000000000000 | 0 | 220000000000000 | 2025-04-10 09:33:25.000 | 0x3965103f852f2677428826d6c8854ff94a847288695ecadce6ae798f7278ac07 |
2 | 0x962c8b71adf855a22b2eb24c726e34452b7e223a | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x962c8b71adf855a22b2eb24c726e34452b7e223a | 2216030000000000000000 | 0 | 220594706350000 | 2025-04-10 09:27:02.000 | 0x415add2656f53d4aadff6e669e7e296ac2cae2f7330cdb32e368898586a79cdd |
3 | 0x6e80164ea60673d64d5d6228beb684a1274bb017 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x929b77d2e64422bc0f60dc03b15e964cbba659a5 | 3082581200000000000000 | 0 | 169542122680306 | 2025-04-10 09:17:20.000 | 0x348fe6f07c69f134b969aad86714bfc289cb1923a4f6ece552d673ef97bf2da6 |
4 | 0x6e80164ea60673d64d5d6228beb684a1274bb017 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x5ba4b589a13f9a5829bdd3b22adf03118ad7daa6 | 9843176000000000000000 | 0 | 541375333736252 | 2025-04-10 09:10:14.000 | 0x70f70feec704684dc71f03a49108421410aa3160a410d72db66b8afb956094dc |
5 | 0x958f480d8e2df0ace2c15d3165bf9d664bd39670 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x958f480d8e2df0ace2c15d3165bf9d664bd39670 | 4727263700000000000000 | 0 | 259999968378823 | 2025-04-10 09:04:51.000 | 0x51638e8908992080d94aedff545a1966b7f5591cc188ba97427caca1df0b5edb |
6 | 0x9076062c0435ee5f61280533510009c46edb9d4b | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x9076062c0435ee5f61280533510009c46edb9d4b | 2511500000000000000000 | 0 | 277287782805429 | 2025-04-10 09:04:37.000 | 0x5e624236c02b001d0f4ad57deec9e77517eb8bb76e9add076038e089204f6ba0 |
7 | 0xf171f8e28b810e870e0ae0e8d5d3502248518fc9 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0xf171f8e28b810e870e0ae0e8d5d3502248518fc9 | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:03:41.000 | 0x43a8bb9dba10665bf2deab65e318de6dbe6df9928d20b6018fedabed869bad16 |
8 | 0xde914b04169e425cec0d594bb0a33c6b8fac13e9 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0xde914b04169e425cec0d594bb0a33c6b8fac13e9 | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:03:41.000 | 0x4425762458f343789e31a2da669fbdf56a7bc3bbe3cf3ea7232d876c9e187d7e |
9 | 0xcd503b874ac760b1b82e910c4dee780d97d6f4ed | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0xcd503b874ac760b1b82e910c4dee780d97d6f4ed | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:03:30.000 | 0xba09b60ec077396134667e0e74f1403c05eb900c5289ec3bded911bd4551674a |
10 | 0x792d222ec6b325120b17686940345871ea8c507d | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x792d222ec6b325120b17686940345871ea8c507d | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:03:19.000 | 0xa81fb89dbddbb71c7ee57d37b0ee4243a1410a3128b7e5d09db737ef4cef2bfd |
11 | 0x00fffd6bbb59b89a4990a1d2dc66e6323af9fa2c | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x00fffd6bbb59b89a4990a1d2dc66e6323af9fa2c | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:02:57.000 | 0xbeb9041e4c55726105944a53e880b11959093a76d57e40e590827b0edd1cfcf6 |
12 | 0x241f6fd04165f9c44323ee0ad378e3aa1ca83c99 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x241f6fd04165f9c44323ee0ad378e3aa1ca83c99 | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:02:31.000 | 0x38fab8ba06056dcf4f5fd72d9dcd6f8ea18e9fc3d1849e4875d9df3d72e9038e |
13 | 0x93e7b310a41450c5f5ff76bea70cd037bbec223d | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x93e7b310a41450c5f5ff76bea70cd037bbec223d | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:02:16.000 | 0xe8f0e9978d3edc2f8373f12dead98b338fe117fbb911cba1b092fbb7b0fbf1d1 |
14 | 0xbf8635826ade7c74025cd23626807f1c0784e4e7 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0xbf8635826ade7c74025cd23626807f1c0784e4e7 | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:02:05.000 | 0x2322192cd07b530793b58c201d8cedf9bf56964b7215009aaa433c4697a9e5ea |
15 | 0x27a425b35af93d59f0dbe081cc5fe928701d7390 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x27a425b35af93d59f0dbe081cc5fe928701d7390 | 2511500000000000000000 | 0 | 272742081447963 | 2025-04-10 09:01:42.000 | 0xfe03604665222d1c702ac66f6653e5b77c93a7e47ce29994cd3c6401cd995fad |
16 | 0x621bbffb2eaaf494d443d804ab8fc552548ea916 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x621bbffb2eaaf494d443d804ab8fc552548ea916 | 5225000000000000000000 | 0 | 287375000000000 | 2025-04-10 08:59:07.000 | 0xbb423675a8ff614df0531640af92e3c0e82e72b40ca02cb307a7c4f606f8ceb4 |
17 | 0x94dd6c702eb0538477f2b70c271bd06198d10d6e | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x94dd6c702eb0538477f2b70c271bd06198d10d6e | 4545449150000000000000 | 0 | 250000000000000 | 2025-04-10 08:44:55.000 | 0x2d31af2e6e94e010f27dccb407ea8c065c1fecb4cbe51fb9ad9fda2481da99de |
18 | 0x6e80164ea60673d64d5d6228beb684a1274bb017 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0xd38f893caf84b9c9fdb151a04befdd58e4cd89e4 | 2363634350000000000000 | 0 | 130000000000000 | 2025-04-10 08:37:00.000 | 0xdbc96a87119eb7feb989ad2fca397b21694d6774c82b0b0bb8a62846123a5eab |
19 | 0x22532a1d9f9817646286e5a16c99b1ac310a66d8 | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x22532a1d9f9817646286e5a16c99b1ac310a66d8 | 4181810000000000000000 | 0 | 230000000000000 | 2025-04-10 08:31:59.000 | 0x6cf2af4c811761b7ff935a905ed111293c90a1f0fe5e821162de59c8da30a284 |
20 | 0x991bc891057047e12827fa21890dbce5586f774e | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0x991bc891057047e12827fa21890dbce5586f774e | 3181814900000000000000 | 0 | 175000000000000 | 2025-04-10 08:30:01.000 | 0x918dbc629180457d454bbf17ebfb27941bff33ae26442d4079d2381bb7eae364 |
datavortexpurring-peach
Updated 2025-04-10
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
›
⌄
⌄
SELECT
origin_from_address,
contract_address,
'0x' || SUBSTR(topics[1], 27) AS borrower_address,
ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64)) AS principal,
ethereum.public.udf_hex_to_int(SUBSTRING(data, 67, 64)) AS interest,
ethereum.public.udf_hex_to_int(SUBSTRING(data, 131, 64)) AS collateral,
block_timestamp,
tx_hash
FROM
mezo.testnet.fact_event_logs
WHERE
topics[0] = '0xf575eb5cdee005607f56587351e18943ddacd11756b9d37980ec251797ff136c'
--and origin_function_signature = '0x8e54c119'
and contract_address = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30'
ORDER BY
block_timestamp DESC
LIMIT 50;
/*
SELECT
'0x' || SUBSTR(topics[1], 27) AS borrower_address,
-- Extract the principal amount from the data field (convert hex to integer)
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64))/1e18 AS principal,
-- Extract the interest amount from the data field
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64))/1e18 AS interest,
-- Extract the collateral amount from the data field
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 131, 64))/1e18 AS collateral,
-- Extract the stake amount from the data field
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 195, 64))/1e18 AS stake,
Last run: 26 days ago
50
14KB
10s