datavortexMonthly Withdrawals
    Updated 2025-05-10
    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";

    Last run: 13 days ago
    Month
    Withdrawers
    Total Withdrawal Transactions
    Total Withdrawn Volume
    Avg Withdrawal Amount
    1
    2022-03-01 00:00:00.0001275462138556.1985262115385.296392275
    2
    2022-04-01 00:00:00.000177929643201875606.70283921746.806711498
    3
    2022-05-01 00:00:00.000129113214175230176.16090442490.343394982
    4
    2022-06-01 00:00:00.000869821968946730.324186920829.827892504
    5
    2022-07-01 00:00:00.000557381216681497.235662310832.141062118
    6
    2022-08-01 00:00:00.00048824701996096.344375151869.004067767
    7
    2022-09-01 00:00:00.00042215512143577.181725994170.383622035
    8
    2022-10-01 00:00:00.00040313546062957.5608025210618.139335906
    9
    2022-11-01 00:00:00.0002701103514215.879386321512.399645254
    10
    2022-12-01 00:00:00.000145593113190.623873414857.504726314
    11
    2023-01-01 00:00:00.00014162790718.073944202662.17572222
    12
    2023-02-01 00:00:00.000146545145046.148504862889.853671809
    13
    2023-03-01 00:00:00.00015512114965843.113068287389.647489685
    14
    2023-04-01 00:00:00.0001125822871509.279439935028.912923713
    15
    2023-05-01 00:00:00.0001044721268183.590947442744.986127592
    16
    2023-06-01 00:00:00.0001083781724354.439204794598.278504546
    17
    2023-07-01 00:00:00.000763962318474.303648475929.601799612
    18
    2023-08-01 00:00:00.000917554031852.096798525375.802795731
    19
    2023-09-01 00:00:00.00011412622526704.844786122016.524217706
    20
    2023-10-01 00:00:00.0001376971824620.232809392636.734440476
    39
    3KB
    14s