Solend Liquidator Count

snowdevSolend Liquidator Count

Updated 2025-03-10

SELECT

t.SIGNERS[0] AS LIQUIDATOR,

SUM(CASE WHEN t.SUCCEEDED THEN 1 ELSE 0 END) AS SUCCESS_COUNT,

SUM(CASE WHEN t.SUCCEEDED THEN 0 ELSE 1 END) AS ERROR_COUNT,

COUNT(*) AS TOTAL_COUNT,

ROUND(100.0 * SUM(CASE WHEN t.SUCCEEDED THEN 1 ELSE 0 END) / COUNT(*), 2) AS SUCCESS_PERCENT

FROM solana.core.fact_transactions t

WHERE t.BLOCK_TIMESTAMP >= CURRENT_DATE - 5

AND ARRAY_TO_STRING(t.ACCOUNT_KEYS, ',') LIKE '%So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo%'

AND ARRAY_TO_STRING(t.LOG_MESSAGES, ',') LIKE '%iquidate%'

GROUP BY t.SIGNERS[0]

ORDER BY SUCCESS_COUNT DESC

LIMIT 500;

Last run: 27 days ago

	LIQUIDATOR	SUCCESS_COUNT	ERROR_COUNT	TOTAL_COUNT	SUCCESS_PERCENT
1	DJtHhTd2JQ7vP4vVVHfCUEQtQ6ZpU8g9dgiEfRHENERK	26	3	29	89.66
2	8Xp2o7t5pxBTywsCHoLezZYNS5MiqLBSbEqTeV6UYiMz	17	0	17	100
3	AFL91WAnJuPUoYdxTbw2wJSudc8YrTcoq5Kwo81gq68c	8	4	12	66.67
4	6vwhhD5KFoiqZyxWYnMPyzL2wdGhihd3LuWtGqGN7ECW	7	0	7	100
5	BZfvv7kaZzZtP1wo8DJB3hzYHtJerE86DTnZ1TP1sFc8	3	398	401	0.75
6	6pH9CSW4Xx8mVQSbLkS9J6F7GG3g146jXz1eiNuzNbmx	2	515	517	0.39
7	SAVEYPDMSAYT2oRLdoHsyaHpWmB1YpWevD5gPqGJE9u	2	391	393	0.51
8	bJpxRiYE6XEhMnhZQNymL76Qoqgkgp4H1SYm75V3rYZ	2	5	7	28.57
9	G1Ln5PJGX4Hcn8HrR1qQRG6SEyyg77KYRir5SrCNm52R	1	0	1	100
10	Cm4xwXdu9DgMHPJJPqSM1mCrD2JkDMWzJwJVx91pZHUv	0	100	100	0

617B

192s

flipside