greyswanMonitor Kamino
    Updated 2024-05-01
    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