SELECT
DATE(snapshot_timestamp) AS activity_date,
COUNT(DISTINCT repo_owner) AS active_developers
FROM
near.core.fact_developer_activity
WHERE
snapshot_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'
GROUP BY
activity_date
ORDER BY
activity_date DESC;