simple sql query modification

i want to get unique md5 records that get added daily requires counting records that are NOT IN .. have not been seen before i'd like to get that by date going back for as long as I have data (say 90 days) here are table fields Table Details: imp_v18_20140916 date_time STRING ip STRING country STRING region STRING zip STRING request_uri STRING referer STRING useragent STRING uuid STRING md5 STRING query to modify is SELECT DATE(date_time) AS date_new, count(DISTINCT md5) AS unique, count(*) AS total_impressions FROM TABLE_DATE_RANGE(li.imp_v18_, DATE_ADD(CURRENT_TIMESTAMP(), -90, 'DAY'), CURRENT_TIMESTAMP()) GROUP BY date_new ORDER BY date_new;