date_trunc('day',block_timestamp) as day,

liquidation_contract_symbol,

count(tx_id) as liquidations,

sum(liquidation_amount_usd) as volume

FROM compound.liquidations

WHERE block_timestamp >= getdate() - interval '60 days'

AND ctoken_symbol <> 'cSAI'

AND ctoken_symbol <> 'cWBTC'

AND liquidation_contract_symbol IS NOT NULL

GROUP BY day,2

ORDER BY day