SELECT

'Lending' AS type,

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_volume

FROM avalanche.defi.ez_lending_deposits

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

GROUP BY 2

),

borrowing AS (

SELECT

'Borrowing' AS type,

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_volume

FROM avalanche.defi.ez_lending_borrows

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

GROUP BY 2

SELECT * FROM lending

UNION ALL

SELECT * FROM borrowing

ORDER BY type, period;