WITH daily_liquidations AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
CASE
WHEN block_timestamp < '2024-12-16 17:00:00.000' THEN 'Before Upgrade'
ELSE 'After Upgrade'
END AS timespan,
SUM(amount) AS total_collateral_liquidated,
SUM(amount_usd) AS total_collateral_liquidated_usd
FROM
avalanche.defi.ez_lending_liquidations
WHERE
block_timestamp >= '2024-12-10'
GROUP BY
date, timespan
)
SELECT
date,
timespan,
total_collateral_liquidated,
total_collateral_liquidated_usd
FROM
daily_liquidations
ORDER BY
date