SocioAnalyticaAll Aave liquidation global stats
    Updated 2025-02-04
    WITH all_liquidations AS (
    SELECT
    'ethereum' as chain,
    platform,
    amount_usd,
    borrower,
    tx_hash,
    collateral_token_symbol,
    debt_token_symbol
    FROM ethereum.defi.ez_lending_liquidations
    WHERE block_timestamp >= '2025-02-02'
    AND block_timestamp < '2025-02-04'
    UNION ALL
    SELECT
    'polygon' as chain,
    platform,
    amount_usd,
    borrower,
    tx_hash,
    collateral_token_symbol,
    debt_token_symbol
    FROM polygon.defi.ez_lending_liquidations
    WHERE block_timestamp >= '2025-02-02'
    AND block_timestamp < '2025-02-04'
    UNION ALL
    SELECT
    'optimism' as chain,
    platform,
    amount_usd,
    borrower,
    tx_hash,
    collateral_token_symbol,
    Last run: 3 months ago
    TOTAL_LIQUIDATIONS
    TOTAL_UNIQUE_WALLETS_LIQUIDATED
    TOTAL_LIQUIDATION_VOLUME_USD
    AVG_LIQUIDATION_SIZE_USD
    NUMBER_OF_CHAINS_AFFECTED
    1
    99306950267601022.6426948.7434682786
    1
    44B
    4s