misaghlbAave Delegates' Gas Usage- numbers comparison proposals
    Updated 2023-03-22
    SELECT
    case when date(a.block_timestamp) > CURRENT_DATE - 90 then '90 - 180 Days Ago' else '90 Days Ago' end splitter,
    COUNT(DISTINCT a.proposal_id) AS "Proposals",
    COUNT(DISTINCT a.proposer) AS "Proposers"
    FROM ethereum.aave.ez_proposals a
    where date(a.block_timestamp) >= CURRENT_DATE - 180
    GROUP BY splitter


    Run a query to Download Data