datavortexProtocol Market Utilization Rate(%)
    Updated 2025-04-16
    WITH market_volume AS (
    SELECT
    protocol_market,
    COUNT(DISTINCT tx_hash) AS num_borrow_events,
    SUM(amount_usd) AS total_market_volume
    FROM gnosis.defi.ez_lending_borrows
    WHERE event_name = 'Borrow'
    GROUP BY protocol_market
    ),

    protocol_name AS (
    SELECT '0x291B5957c9CBe9Ca6f0b98281594b4eB495F4ec1' AS protocol_market, 'agUSDC' AS protocol_name UNION ALL
    SELECT '0xd0dd6cef72143e22cced4867eb0d5f2328715533', 'Aave Gnosis WXDAI' UNION ALL
    SELECT '0xd4e420bBf00b0F409188b338c5D87Df761d6C894', 'agWXDAI' UNION ALL
    SELECT '0xa1fa064a85266e2ca82dee5c5ccec84df445760e', 'Aave Gnosis GNO' UNION ALL
    SELECT '0xa286Ce70FB3a6269676c8d99BD9860DE212252Ef', 'agLINK' UNION ALL
    SELECT '0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb', 'Spark WXDAI' UNION ALL
    SELECT '0x44932e3b1e662adde2f7bac6d5081c5adab908c6', 'Wrapped ether on dai' UNION ALL
    SELECT '0xA26783eAd6C1f4744685c14079950622674ae8A8', 'agGNO' UNION ALL
    SELECT '0xc6b7aca6de8a6044e0e32d0c841a89244a10d284', 'Aave Gnosis USDC' UNION ALL
    SELECT '0x4863cfaF3392F20531aa72CE19E5783f489817d6', 'agWBTC' UNION ALL
    SELECT '0x44932e3b1E662AdDE2F7bac6D5081C5adab908c6', 'agWETH' UNION ALL
    SELECT '0xa26783ead6c1f4744685c14079950622674ae8a8', 'Gnosis Token on xDai' UNION ALL
    SELECT '0xA916A4891D80494c6cB0B49b11FD68238AAaF617', 'agFOX' UNION ALL
    SELECT '0x5b4Ef67c63d091083EC4d30CFc4ac685ef051046', 'agUSDT' UNION ALL
    SELECT '0xEB20B07a9abE765252E6b45e8292b12CB553CcA6', 'agEURe' UNION ALL
    SELECT '0x606B2689ba4A9F798f449fa6495186021486dD9f', 'agwstETH' UNION ALL
    SELECT '0xe1cF0d5A56c993c3C2a0442dd645386aEFF1fC9a', 'agsDAI' UNION ALL
    SELECT '0xa818f1b57c201e092c4a2017a91815034326efd1', 'Aave Gnosis WETH' UNION ALL
    SELECT '0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a', 'Aave Gnosis wstETH' UNION ALL
    SELECT '0xedbc7449a9b594ca4e053d9737ec5dc4cbccbfb2', 'Monerium EUR emoney'
    )
    SELECT
    COALESCE(pn.protocol_name, pm.protocol_market) AS protocol_name,
    COALESCE(mv.num_borrow_events, 0) AS num_borrow_events,
    COALESCE(mv.total_market_volume, 0) AS total_market_volume,
    Last run: about 1 month ago
    PROTOCOL_NAME
    NUM_BORROW_EVENTS
    TOTAL_MARKET_VOLUME
    MARKET_UTILIZATION_PERCENTAGE
    1
    Aave Gnosis WXDAI660176767949.8522.62385092
    2
    Aave Gnosis WETH532462721075.5518.484175565
    3
    Aave Gnosis GNO652535552925.4310.477602779
    4
    Aave Gnosis wstETH213625508901.97.517585071
    5
    0x27ad5c237bf3f5707d244813f6748cd28fddb368471715576119.634.590350649
    6
    Monerium EUR emoney490414029357.524.134513083
    7
    Spark WXDAI172912154356.143.581941968
    8
    0xc0333cb85b59a788d8c7cae5e1fd6e229a3e5a65132312152195.483.581305212
    9
    Gnosis Token on xDai466611130423.433.280184515
    10
    Aave Gnosis USDC269711124767.463.278517676
    10
    558B
    7s