elsinaAVG Per user
    Updated 2 days ago
    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
    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.2011260.00074148955720.000528602571812463.2484632628508.665804948
    1
    75B
    11s