AVG_TX_COUNT_PER_USER | AVG_COLLATERAL_PER_USER | AVG_COLLATERAL_PER_TX | AVG_MUSD_AMOUNT_PER_USER | AVG_MUSD_AMOUNT_PER_TX | |
---|---|---|---|---|---|
1 | 1.201126 | 0.0007414895572 | 0.0005286025718 | 12463.248463262 | 8508.665804948 |
elsinaAVG Per user
Updated 2 days 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' --BorrowerOperations contract
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' --BorrowerOperations contract
and tx_succeeded = 'True'
and ORIGIN_FUNCTION_SIGNATURE = '0x8e54c119' --adjustTrove
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[0])::float / POW(10, 18) AS borrow
Last run: 2 days ago
1
75B
11s