flipside

    Monthly liquidation Calls
    datavortexMonthly liquidation Calls
    Updated 2025-04-16
    SELECT
    DATE_TRUNC('month', block_timestamp::date) AS month,
    event_name,
    platform,
    COUNT(tx_hash) AS event_count,
    SUM(amount_usd) AS total_volume_liquidated
    FROM gnosis.defi.ez_lending_liquidations
    GROUP BY month, event_name, platform
    ORDER BY month, event_count DESC;

    Last run: 21 days ago
    MONTH
    EVENT_NAME
    PLATFORM
    EVENT_COUNT
    TOTAL_VOLUME_LIQUIDATED
    1
    		2022-05-01 00:00:00.000LiquidationCallAgave41109.07
    2
    		2022-06-01 00:00:00.000LiquidationCallAgave17652.36
    3
    		2022-06-01 00:00:00.000LiquidationCallrealt1
    4
    		2022-07-01 00:00:00.000LiquidationCallAgave2116.87
    5
    		2022-08-01 00:00:00.000LiquidationCallAgave30.02
    6
    		2022-09-01 00:00:00.000LiquidationCallAgave31.74
    7
    		2022-10-01 00:00:00.000LiquidationCallAgave294.65
    8
    		2022-11-01 00:00:00.000LiquidationCallAgave1720238.56
    9
    		2022-11-01 00:00:00.000LiquidationCallrealt1
    10
    		2023-01-01 00:00:00.000LiquidationCallAgave6411007.56
    11
    		2023-01-01 00:00:00.000LiquidationCallrealt3
    12
    		2023-02-01 00:00:00.000LiquidationCallrealt5
    13
    		2023-03-01 00:00:00.000LiquidationCallrealt1
    14
    		2023-05-01 00:00:00.000LiquidationCallrealt3
    15
    		2023-06-01 00:00:00.000LiquidationCallrealt2
    16
    		2023-07-01 00:00:00.000LiquidationCallrealt2
    17
    		2023-08-01 00:00:00.000LiquidationCallrealt2
    18
    		2023-09-01 00:00:00.000LiquidationCallrealt2
    19
    		2023-10-01 00:00:00.000LiquidationCallSpark27.67
    20
    		2023-10-01 00:00:00.000LiquidationCallrealt1
    68
    4KB
    2s