SELECT date_trunc('day', created_at) AS day, COUNT(*) AS signups

SELECT date_trunc('day', created_at) AS day, COUNT(*) AS signups FROM users GROUP BY 1 ORDER BY 1 DESC LIMIT 30;