WITH minPlatfrom AS (
SELECT DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Date, PLATFORM
FROM arbitrum.defi.ez_lending_liquidations
WHERE date != CURRENT_DATE AND Date >= '2023-03-20'
)
SELECT PLATFORM, COUNT(PLATFORM) AS Countliqui
FROM minPlatfrom
WHERE PLATFORM = 'Radiant V2' OR PLATFORM = 'Aave V3'
GROUP by PLATFORM, DATE
ORDER BY DATE