greyswanMonitor Kamino
Updated 2024-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc ('day', BLOCK_TIMESTAMP) as day,
count (distinct tx_id) as number_of_liquidations
from
solana.core.ez_events_decoded
where
PROGRAM_ID = 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD'
and succeeded = 'true'
and BLOCK_TIMESTAMP >= current_date - 40
and event_type = 'liquidateObligationAndRedeemReserveCollateral'
group by date_trunc ('day', BLOCK_TIMESTAMP)
order by date_trunc ('day', BLOCK_TIMESTAMP) desc
QueryRunArchived: QueryRun has been archived