Count total unique rows for each date and group by date
SELECT COUNT(DISTINCT srctable.email), dates.date_added
FROM srctable
JOIN ( SELECT DISTINCT date_added 
       FROM srctable ) dates ON srctable.date_added &lt;= dates.date_added
GROUP BY dates.date_added