picasoimplicit-orange
    Updated 2025-01-22
    SELECT
    DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS donation_month,
    COUNT(DISTINCT DONOR_ADDRESS) AS unique_donors_count
    FROM
    crosschain.olas.ez_service_donations
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)
    GROUP BY
    donation_month
    ORDER BY
    donation_month;
    QueryRunArchived: QueryRun has been archived