CryptoLioncomp liquidations
    Updated 2021-06-14
    SELECT
    date_trunc('day',block_timestamp) as day,
    SUM(liquidation_amount_usd) as liquidation_value,
    COUNT(tx_id) as liquidations
    FROM compound.liquidations
    WHERE block_timestamp >= getdate() - interval '6 months'
    GROUP BY 1
    ORDER BY 1