date_trunc('day',block_timestamp) as day,

compound.liquidations.liquidation_contract_symbol,

avg(liquidation_amount_usd) as liquidation_amount_usd,

count(DISTINCT compound.liquidations.liquidator) as distinct_liquidators,

count(liquidator) as liquidations

FROM compound.liquidations

WHERE compound.liquidations.block_timestamp > getdate() - interval '30 days'

AND liquidation_amount_usd > 0

AND

( liquidation_contract_symbol = 'WBTC'

OR liquidation_contract_symbol = 'WBTC2'

OR liquidation_contract_symbol = 'ETH'

OR liquidation_contract_symbol = 'DAI'

OR liquidation_contract_symbol = 'USDC'

OR liquidation_contract_symbol = 'USDT'

)

GROUP BY day,

ctoken_symbol,

liquidation_contract_symbol

ORDER BY 1 DESC