flipside

    montly
    datavortexmontly
    Updated 3 days ago
    SELECT
    DATE_TRUNC('month', block_timestamp) AS "Month",
    COUNT(DISTINCT sender_id) AS "Borrowers",
    COUNT(DISTINCT tx_hash) AS "Total Borrow Transactions",
    SUM(amount_usd) AS "Total Borrowed Volume",
    AVG(amount_usd) AS "Avg Borrowed Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('borrow')
    GROUP BY
    DATE_TRUNC('month', block_timestamp)
    ORDER BY
    "Month";
    Last run: 3 days ago
    Month
    Borrowers
    Total Borrow Transactions
    Total Borrowed Volume
    Avg Borrowed Amount
    1
    		2022-03-01 00:00:00.0001224922822392.7672965822399.942597592
    2
    		2022-04-01 00:00:00.000161122097127873671.7957420568.388579016
    3
    		2022-05-01 00:00:00.000578473252801579.529380544937.51449309
    4
    		2022-06-01 00:00:00.000288287235686479.628082729788.380323942
    5
    		2022-07-01 00:00:00.00018011126254835.1447002917973.664208909
    6
    		2022-08-01 00:00:00.000176754404405.4213210172364.943984333
    7
    		2022-09-01 00:00:00.000155581215753.7609448311610.102693618
    8
    		2022-10-01 00:00:00.0001304901552054.702162869129.733542134
    9
    		2022-11-01 00:00:00.0009694440079.561672277272.650079403
    10
    		2022-12-01 00:00:00.0006928524815.064988789393.889920457
    11
    		2023-01-01 00:00:00.0007124537553.669739788560.50253343
    12
    		2023-02-01 00:00:00.00068211128434.4019303391337.858353441
    13
    		2023-03-01 00:00:00.000855572319154.853861967339.097638804
    14
    		2023-04-01 00:00:00.000722781408306.514107145065.85077017
    15
    		2023-05-01 00:00:00.00056203451051.721111512221.929660648
    16
    		2023-06-01 00:00:00.00046165492628.9203280712985.62982017
    17
    		2023-07-01 00:00:00.000442391123702.597706334701.684509231
    18
    		2023-08-01 00:00:00.0006141833998150.40133544955.809323771
    19
    		2023-09-01 00:00:00.0005619251852285.81675589962.226398315
    20
    		2023-10-01 00:00:00.0008115521484015.93020836956.19583132
    37
    2KB
    11s