kitlunaAccumulated Amount of USDT Borrowed and Repaid/Kashi Borrowing Pools
    Updated 2022-07-14
    WITH borrow AS (
    SELECT
    date_trunc ('month', block_timestamp) AS "date",
    SUM (AMOUNT) AS borrowed_amount,
    SUM (borrowed_amount) over (order by "date") as acm_borrowed
    FROM flipside_prod_db.crosschain.ez_borrowing
    WHERE ACTION = 'Borrow'
    AND SYMBOL = 'USDT'
    GROUP BY "date"
    ORDER BY "date"
    ),

    repay AS (
    SELECT
    date_trunc ('month', block_timestamp) AS "date",
    SUM (AMOUNT) AS repaid_amount,
    SUM (repaid_amount) over (order by "date") as acm_repaid
    FROM flipside_prod_db.crosschain.ez_borrowing
    WHERE ACTION = 'Repay'
    AND SYMBOL = 'USDT'
    GROUP BY "date"
    ORDER BY "date"
    )

    SELECT
    b."date",
    a.acm_borrowed,
    b.acm_repaid
    FROM borrow a
    FULL JOIN repay b ON a."date" = b."date"
    ORDER BY "date"

    Run a query to Download Data