datavortexTop Withdrawer
    Updated 2025-01-21
    SELECT
    sender_id AS "Withdrawer",
    COUNT(DISTINCT tx_hash) AS "Total Withdraw Transactions",
    SUM(amount_usd) AS "Total Withdrawn Volume",
    AVG(amount_usd) AS "Avg Withdrawn Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions = 'withdraw_succeeded'
    AND amount_usd IS NOT NULL
    GROUP BY
    sender_id
    ORDER BY
    "Total Withdrawn Volume" DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived