flipside

    weekly
    datavortexweekly
    Updated 2025-05-10
    SELECT
    DATE_TRUNC('month', block_timestamp) AS "Month",
    COUNT(DISTINCT sender_id) AS "Depositor",
    COUNT(DISTINCT tx_hash) AS "Total Deposit Transactions",
    SUM(amount_usd) AS "Total Deposited Volume",
    AVG(amount_usd) AS "Avg Deposited Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('deposit', 'deposit_to_reserve')
    GROUP BY
    DATE_TRUNC('month', block_timestamp)
    ORDER BY
    "Month";
    Last run: 11 days ago
    Month
    Depositor
    Total Deposit Transactions
    Total Deposited Volume
    Avg Deposited Amount
    1
    		2022-03-01 00:00:00.0001285743868757.7592678423734.710179557
    2
    		2022-04-01 00:00:00.000189230988214188854.6208721687.814360153
    3
    		2022-05-01 00:00:00.000131213570162253677.28224139012.665852907
    4
    		2022-06-01 00:00:00.000835780468244075.756795626783.389229512
    5
    		2022-07-01 00:00:00.000406320114594818.539738112858.870960122
    6
    		2022-08-01 00:00:00.00037719291686774.739676162918.295397364
    7
    		2022-09-01 00:00:00.00028114201568550.026861224273.978274826
    8
    		2022-10-01 00:00:00.00025512352583690.207785185703.510392462
    9
    		2022-11-01 00:00:00.0002171521460819.4743317581515.853533986
    10
    		2022-12-01 00:00:00.00011458239188.128345514653.135472425
    11
    		2023-01-01 00:00:00.00012670366460.63194706400.365252693
    12
    		2023-02-01 00:00:00.00011546041259.441699563330.075533597
    13
    		2023-03-01 00:00:00.00014512584190230.877026056377.824774773
    14
    		2023-04-01 00:00:00.0001006172513478.445272944100.291101587
    15
    		2023-05-01 00:00:00.000814561453580.975122013273.83102505
    16
    		2023-06-01 00:00:00.0001093141458964.685293784646.384348069
    17
    		2023-07-01 00:00:00.000814071666364.75408764094.262295056
    18
    		2023-08-01 00:00:00.0009650903738127.90978118734.406269112
    19
    		2023-09-01 00:00:00.0009319232476237.06389391288.364757489
    20
    		2023-10-01 00:00:00.00012619682281590.136003861159.93397865
    39
    3KB
    17s