permaryenormous-white
    Updated 2025-02-19
    SELECT
    DATE_TRUNC('day', closed_at) AS day,
    COUNT(DISTINCT id) AS total_ledgers
    FROM stellar.core.fact_ledgers
    WHERE closed_at >= DATEADD('day', -30, CURRENT_TIMESTAMP())
    AND closed_at <= CURRENT_TIMESTAMP()
    GROUP BY 1
    ORDER BY 1;
    QueryRunArchived: QueryRun has been archived