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