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"