SELECT  ((time_track + 330) - mod((time_track + 330), 1440)) as date, sum(click_count) as clicks, sum(conv_count) as conversions, sum(payout) as payout, sum(revenue) as revenue FROM "offer_aff_reports" WHERE ("offer_aff_reports"."time_track" BETWEEN 24193110 AND 24237749) GROUP BY date LIMIT 30 OFFSET 0

SELECT COUNT(*) AS count_all, date AS date FROM "offer_aff_reports" WHERE ("offer_aff_reports"."time_track" BETWEEN 24193110 AND 24237749) GROUP BY date

SELECT COUNT(*) AS count_all, ((time_track + 330) - mod((time_track + 330), 1440)) as date FROM "offer_aff_reports" WHERE ("offer_aff_reports"."time_track" BETWEEN 24193110 AND 24237749) GROUP BY date