Incrementlending-liquidation-usdc
Updated 2024-04-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- 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