Incrementlending-liquidation-stflow
    Updated 2024-04-15
    -- stFlow lending pool
    SELECT
    block_timestamp,
    tx_id,
    event_data:liquidator AS Liquidator,
    event_data:borrower AS Borrower,
    (event_data:scaledActualRepaidUnderlying / 1e18) AS repaidStflow,
    (
    event_data:scaledCollateralPoolLpTokenSeized / 1e18
    ) AS liquidatedLpAmount,
    (event_data:collateralPoolToSeize) AS liquidated_pool
    FROM
    flow.core.fact_events
    WHERE
    event_contract = 'A.44fe3d9157770b2d.LendingPool'
    AND event_type = 'Liquidate'
    ORDER BY
    block_timestamp DESC
    QueryRunArchived: QueryRun has been archived