datavortexmontly stat per stable coins
    Updated 2025-01-21
    SELECT
    DATE_TRUNC('month', block_timestamp) AS "Month",
    symbol AS "Stablecoin",
    COUNT(DISTINCT 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'
    GROUP BY
    DATE_TRUNC('month', block_timestamp), symbol
    ORDER BY
    "Month", symbol;

    QueryRunArchived: QueryRun has been archived