datavortexMonthly Withdrawals
    Updated 2025-01-21
    SELECT
    DATE_TRUNC('month', block_timestamp) AS "Month",
    COUNT(DISTINCT sender_id) AS "Withdrawers",
    COUNT(DISTINCT tx_hash) AS "Total Withdrawal Transactions",
    SUM(amount_usd) AS "Total Withdrawn Volume",
    AVG(amount_usd) AS "Avg Withdrawal Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('withdraw_succeeded')
    GROUP BY
    DATE_TRUNC('month', block_timestamp)
    ORDER BY
    "Month";

    QueryRunArchived: QueryRun has been archived