SpecterMarket share by AAve and Radiant
    Updated 2024-05-02

    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
    QueryRunArchived: QueryRun has been archived