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;