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