WITH
liquidations as (
SELECT
block_timestamp,
date_trunc('day',block_timestamp) as dates,
borrower,
liquidated_amount,
liquidated_amount_usd,
liquidated_currency,
repay_amount_usd
FROM anchor.liquidations
),
number_of_liquidation_by_dates as (
SELECT
dates,
count(dates) as number_of_liquidations
FROM liquidations
GROUP BY dates
ORDER BY dates ASC
)
SELECT