N_TXN | N_BORROWERS | TOTAL_DEBT | TOTAL_COLLATERAL | TOTAL_COLLATERAL_USD | AVG_DEBT | AVG_COLLAT | MEDIAN_DEBT | MEDIAN_COLLAT | AVG_DEBT_PER_BORROWER | AVG_COLLAT_PER_BORROWER | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 35160 | 29436 | 331131713.87949 | 20.388297172 | 1799837.24283087 | 9417.853068244882 | 0.0005798719332 | 2424.24 | 0.000155 | 11249.20892374949 | 0.0006926313756 |
0xHaM-dTotal
Updated 2025-05-13
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 priceTb as (
select
hour,
price
from ethereum.price.ez_prices_hourly
where SYMBOL = 'WBTC'
and hour::date >= '2025-03-01'
)
,
openTrove as (
select
BLOCK_TIMESTAMP,
tx_hash,
FROM_ADDRESS as borrower_add,
value as collateral,
value*price as collateral_usd,
regexp_substr_all(SUBSTR(INPUT, 11, len(INPUT)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[1])::int/1e18 as debt_value,
from mezo.testnet.fact_traces
join priceTb on trunc(BLOCK_TIMESTAMP, 'hour') = hour
where TO_ADDRESS = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30'
and left(input,10) ilike '0x8f09162b'
and tx_succeeded = 'True'
)
,
adjustTrove as (
select
BLOCK_TIMESTAMP,
tx_hash,
FROM_ADDRESS as borrower_add,
value as collateral,
value*price as collateral_usd,
regexp_substr_all(SUBSTR(INPUT, 11, len(INPUT)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(segmented_data[1])::int/1e18 as debt_value,
ethereum.public.udf_hex_to_int(segmented_data[2])::int/1e18 as adjust_amt,
ethereum.public.udf_hex_to_int(segmented_data[3])::int/1e18 as increase_debt,
Last run: 18 days ago
1
146B
6s