TX_COUNT | UNIQUE_USER | COLLATERAL | AVG_COLLATERAL | MUSD_BORROW | AVG_MUSD_BORROW | |
|---|---|---|---|---|---|---|
1 | 20908 | 17407 | 12.907108722 | 0.0006173287125 | 216947766 | 10376.304094127 |
elsinaTotal Trove Activity
Updated 2025-04-30
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,
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' --BorrowerOperations contract
and tx_succeeded = 'True'
and ORIGIN_FUNCTION_SIGNATURE = '0x8f09162b' --openTrove
union all
select
tx_hash,
from_address,
value,
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' --BorrowerOperations contract
and tx_succeeded = 'True'
and ORIGIN_FUNCTION_SIGNATURE = '0x8e54c119' --adjustTrove
union all
select
tx_hash,
from_address,
value,
regexp_substr_all(SUBSTR(INPUT_data, 11, len(INPUT_data)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[0])::float / POW(10, 18) AS musd_amount
from mezo.testnet.fact_transactions
Last run: 12 days ago
1
70B
27s