SocioAnalyticaAll Aave liquidations1 all time
    Updated 2025-02-04
    -- forked from elvis / All Aave liquidations1 @ https://flipsidecrypto.xyz/elvis/q/DZGvO5BApiRL/all-aave-liquidations1

    WITH all_liquidations AS (
    SELECT
    date_trunc('week', block_timestamp) as week,
    'ethereum' as chain,
    platform,
    amount_usd,
    borrower,
    tx_hash,
    collateral_token_symbol,
    debt_token_symbol
    FROM ethereum.defi.ez_lending_liquidations
    WHERE block_timestamp >= '2021-01-01'
    AND block_timestamp < '2025-02-04'
    UNION ALL
    SELECT
    date_trunc('week', block_timestamp) as week,
    'polygon' as chain,
    platform,
    amount_usd,
    borrower,
    tx_hash,
    collateral_token_symbol,
    debt_token_symbol
    FROM polygon.defi.ez_lending_liquidations
    WHERE block_timestamp >= '2021-01-01'
    AND block_timestamp < '2025-02-04'
    UNION ALL
    SELECT
    date_trunc('week', block_timestamp) as week,
    'optimism' as chain,
    Last run: 3 months ago
    WEEK
    CHAIN
    PLATFORM
    DEBT_TOKEN_SYMBOL
    NUMBER_OF_LIQUIDATIONS
    UNIQUE_LIQUIDATED_WALLETS
    LIQUIDATION_VOLUME_USD
    CUMULATIVE_LIQUIDATIONS_ALL
    CUMULATIVE_VOLUME_USD_ALL
    1
    2025-02-03 00:00:00.000arbitrumAave V3ARB33251.172104352807976651.98
    2
    2025-02-03 00:00:00.000arbitrumAave V3DAI3760140455.022145543012302613.38
    3
    2025-02-03 00:00:00.000arbitrumAave V3EURS21357.62144533010899855.4
    4
    2025-02-03 00:00:00.000arbitrumAave V3FRAX33565.582145853012426582.93
    5
    2025-02-03 00:00:00.000arbitrumAave V3GHO212252806.152145823012426017.35
    6
    2025-02-03 00:00:00.000arbitrumAave V3LUSD33737.162145883012427320.09
    7
    2025-02-03 00:00:00.000arbitrumAave V3USDC8538968384993.682167893042917068.31
    8
    2025-02-03 00:00:00.000arbitrumAave V3USDT7196568409246.252175083051326314.56
    9
    2025-02-03 00:00:00.000arbitrumAave V3WBTC64821262302.962145173012162158.36
    10
    2025-02-03 00:00:00.000arbitrumAave V3WETH181847585.862175293051373912.35
    11
    2025-02-03 00:00:00.000avalancheAave V2DAI.e653964.12151783016802039.31
    12
    2025-02-03 00:00:00.000avalancheAave V2USDC.e312632682.132151723016798075.21
    13
    2025-02-03 00:00:00.000avalancheAave V2USDT.e221736858.632117702930763093.24
    14
    2025-02-03 00:00:00.000avalancheAave V2WBTC.e99112.972151873016802152.28
    15
    2025-02-03 00:00:00.000avalancheAave V3AUSD651385.642151933016803537.92
    16
    2025-02-03 00:00:00.000avalancheAave V3BTC.b33314035.292151413016765393.08
    17
    2025-02-03 00:00:00.000avalancheAave V3DAI.e171731918.872104292807971079.07
    18
    2025-02-03 00:00:00.000avalancheAave V3FRAX110.622151983016803592.21
    19
    2025-02-03 00:00:00.000avalancheAave V3LINK.e1145.022104002807178376.63
    20
    2025-02-03 00:00:00.000avalancheAave V3USDC2772451696372.042155143023117249.35
    ...
    9034
    783KB
    5s