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