SELECT

DATE_TRUNC('week', block_timestamp) AS week,

CASE

WHEN block_timestamp BETWEEN DATEADD(day, -60, '2024-12-17') AND '2024-12-17' THEN 'Before Crash'

WHEN block_timestamp BETWEEN '2024-12-17' AND CURRENT_DATE THEN 'After Crash'

END AS period,

SUM(amount_usd) AS total_borrowing

FROM avalanche.defi.ez_lending_borrows

WHERE block_timestamp BETWEEN DATEADD(day, -60, '2024-12-17') AND CURRENT_DATE

GROUP BY 1, 2

SELECT * FROM weekly_borrowing

ORDER BY week;