FROM_ADDRESS | TX_COUNT | TOTAL_COLLATERAL_AMOUNT | AVG_COLLATERAL_AMOUNT | TOTAL_MUSD_AMOUNT | AVG_MUSD_AMOUNT | TOTAL_REPAY_AMOUNT | |
|---|---|---|---|---|---|---|---|
1 | 0x3391d8c5f92d6020ec8d8e13e10a69391085f4b0 | 18 | 2.88440792 | 0.1602448844 | 51965284.7 | 2886960.26111111 | 200 |
2 | 0xcfe04b1fadca7ea3ce90aeb08907d2672db2f515 | 1 | 0.4999950274 | 0.4999950274 | 7489000 | 7489000 | 0 |
3 | 0x440ea357667969fa73c602573c37eac6678eb552 | 1 | 0.444 | 0.444 | 7598599 | 7598599 | 0 |
4 | 0xd66c34ecae068c634d07600b1e92030799d54730 | 1 | 0.414 | 0.414 | 7305000 | 7305000 | 0 |
5 | 0xd03c86a83c291fd0c026dead54d20f5229a082ca | 1 | 0.4 | 0.4 | 7144667.57 | 7144667.57 | 0 |
6 | 0xb2e0a30bc5a2771181bce1d899dfac84a0e0a3b4 | 1 | 0.399 | 0.399 | 6900069 | 6900069 | 0 |
7 | 0xeb8c7511df7af644ec3e7decfd6d3209f02ff481 | 1 | 0.398 | 0.398 | 7143355 | 7143355 | 0 |
8 | 0x05519d8dd01a7e9735423464ce6f4d09761f0607 | 1 | 0.3883 | 0.3883 | 6943582.08 | 6943582.08 | 0 |
9 | 0x02170e85a5f92467df0f7a32dcbece6b0963ec5f | 1 | 0.331295 | 0.331295 | 5993378.56 | 5993378.56 | 0 |
10 | 0xa62619f66076943dbe448ae56e6f9a4d45211ff3 | 1 | 0.2899999901 | 0.2899999901 | 2000 | 2000 | 0 |
11 | 0x7433cede19df35236af4b40e140500199339f95f | 1 | 0.269995 | 0.269995 | 4884378.1 | 4884378.1 | 0 |
12 | 0xa4f6f39cfa76f084252f08544c8d817f1edeb973 | 1 | 0.2379881396 | 0.2379881396 | 4199945 | 4199945 | 0 |
13 | 0xc2757dd4299ac88b19d33d6b6bba7e68615b8690 | 1 | 0.15444 | 0.15444 | 2772062.41 | 2772062.41 | 0 |
14 | 0x5de50cb6beceec9319076ba37c6e56f7c25593a3 | 2 | 0.1404871745 | 0.07024358725 | 2515000 | 1257500 | 0 |
15 | 0xd15b0342ded129c3bae109f4731ff0ae614592e3 | 21 | 0.07698639561 | 0.003666018839 | 1388598.18 | 66123.722857143 | 1000 |
16 | 0x9c57027b1eca93093a6f446422c59c85a5a3fa52 | 1 | 0.0695568 | 0.0695568 | 1258178.19 | 1258178.19 | 0 |
17 | 0x5273024cc896666711a6daf365948a58704aebb7 | 28 | 0.06433606851 | 0.002297716733 | 1158356.32 | 41369.868571429 | 0 |
18 | 0x17ede21b60c44a0139968e0d1d9a001d2bdc8f85 | 2 | 0.06077188681 | 0.03038594341 | 1090001.44 | 545000.72 | 0 |
19 | 0x16989e007afbe6b06c4f3463477896eb521d4c82 | 1 | 0.0597 | 0.0597 | 1077878 | 1077878 | 0 |
20 | 0x00a36bf34c91e0f240b287fa1fb510a0b0479ff9 | 1 | 0.05 | 0.05 | 700000 | 700000 | 0 |
elsinaPer user
Updated 20 hours ago
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
›
⌄
with base as (
select
tx_hash,
from_address,
value as collateral,
regexp_substr_all(SUBSTR(INPUT_data, 11, len(INPUT_data)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[1])::float / POW(10, 18) AS borrow
from mezo.testnet.fact_transactions
where
to_address = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30'
and tx_succeeded = 'True'
and ORIGIN_FUNCTION_SIGNATURE = '0x8f09162b' -- openTrove
union all
select
tx_hash,
from_address,
value as collateral,
regexp_substr_all(SUBSTR(INPUT_data, 11, len(INPUT_data)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[2])::float / POW(10, 18) AS borrow
from mezo.testnet.fact_transactions
where
to_address = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30'
and tx_succeeded = 'True'
and ORIGIN_FUNCTION_SIGNATURE = '0x8e54c119' -- adjustTrove
),
repay as (
select
from_address,
sum(ethereum.public.udf_hex_to_int(
regexp_substr_all(SUBSTR(INPUT_data, 11, len(INPUT_data)), '.{64}')[0]
)::float / POW(10, 18)) as total_repay_amount
from mezo.testnet.fact_transactions
where
Last run: about 20 hours ago
...
5604
481KB
16s