flipside

    Top Depositors With Most Withdrawals
    datavortexTop Depositors With Most Withdrawals
    Updated 2025-04-16
    WITH price_data AS (
    SELECT
    symbol,
    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS avg_price
    FROM
    gnosis.price.ez_prices_hourly
    GROUP BY
    symbol
    )

    SELECT
    w.depositor,
    ROUND(SUM(w.amount * pd.avg_price), 2) AS "Total Withdrawal (USD)"
    FROM
    gnosis.defi.ez_lending_withdraws w
    JOIN
    price_data pd ON w.token_symbol = pd.symbol
    WHERE
    w.amount IS NOT NULL
    GROUP BY
    w.depositor
    HAVING
    SUM(w.amount * pd.avg_price) > 100000
    ORDER BY
    SUM(w.amount * pd.avg_price) DESC
    LIMIT 10;

    Last run: 21 days ago
    DEPOSITOR
    Total Withdrawal (USD)
    1
    		0xf73375e9590fb58458e56bb5f177aef0f74e7fd165227815
    2
    		0x458cd345b4c05e8df39d0a07220feb4ec19f5e6f28938759.09
    3
    		0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d458124047518.61
    4
    		0x80dc050a8c923c0051d438026f1192d53033728c21286746.58
    5
    		0x461528a443b0e92bb2706cd3260f31e90048893d15744645
    6
    		0xfe76366a986b72c3f2923e05e6ba07b7de5401e412744682.55
    7
    		0x7b9c12915c594a68de96201cbdc79147f09da27812220909.86
    8
    		0xba89d61dd463c7d584a4a6c4645d4692abda28da11746482.5
    9
    		0xba1333333333a1ba1108e8412f11850a5c319ba911073327.65
    10
    		0x2a36c23f113053e08bbdf4a6db30fc37fe0b106810876288.14
    10
    584B
    7s