alleria126. [Hard] Liquidation Risks
    Updated 2021-12-24
    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
    Run a query to Download Data