snowdevMarginFi Liquidations
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
t.BLOCK_TIMESTAMP,
t.TX_ID,
t.SIGNERS[0] AS LIQUIDATOR,
t.SUCCEEDED
FROM solana.core.fact_transactions t
WHERE t.BLOCK_TIMESTAMP >= CURRENT_DATE - 5
AND ARRAY_TO_STRING(t.ACCOUNT_KEYS, ',') LIKE '%MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA%'
AND ARRAY_TO_STRING(t.LOG_MESSAGES, ',') LIKE '%iquidate%'
ORDER BY t.BLOCK_TIMESTAMP DESC
LIMIT 100;
Last run: 2 days ago
100
17KB
47s