Here is a little snippet that will return new signups (or new records) for today

select id, email, created_at::date date from signups 
where email not in (select distinct email from signups where created_at < current_date)