payable-pink

datavortexpayable-pink

Updated 2025-04-16

WITH market_volume AS (

SELECT

protocol_market,

COUNT(DISTINCT tx_hash) AS num_deposit_events,

SUM(amount_usd) AS total_market_volume

FROM gnosis.defi.ez_lending_deposits

WHERE event_name = 'Deposit'

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_deposit_events, 0) AS num_deposit_events,

COALESCE(mv.total_market_volume, 0) AS total_market_volume,

Last run: 19 days ago

	PROTOCOL_NAME	NUM_DEPOSIT_EVENTS	TOTAL_MARKET_VOLUME	MARKET_UTILIZATION_PERCENTAGE
1	Spark WXDAI	1832	92342414.49	12.70777264
2	0x9ee4271e17e3a427678344fd2ee64663cb78b4be	1836	19171353.11	2.638280555
3	0xe877b96caf9f180916bf2b5ce7ea8069e0123182	1516	18255297.45	2.512216848
4	0xe1cf0d5a56c993c3c2a0442dd645386aeff1fc9a	627	13635010.86	1.876392543
5	0xd4e420bbf00b0f409188b338c5d87df761d6c894	2734	13087731.95	1.801078333
6	0x7349c9eaa538e118725a6130e0f8341509b9f8a0	13213	11346449.91	1.561450462
7	0x5671b0b8ac13dc7813d36b99c21c53f6cd376a14	545	10870499.84	1.495952225
8	0x0ca4f5554dd9da6217d62d8df2816c82bba4157b	13100	10819437.88	1.488925294
9	0xb5a165d9177555418796638447396377edf4c18a	5212	9735097.64	1.339702975
10	Wrapped ether on dai	5182	9469556.16	1.30316028

705B

flipside