SELECT d.name, d.ndetails,
(SELECT RAW c FROM d.details AS c ORDER BY c.timestamp DESC OFFSET 0 LIMIT 100) AS details
FROM ( SELECT
b.name,
COUNT(1) AS ndetails,
ARRAY_AGG(c) AS details
FROM bucketName AS a
UNNEST a.validationResults AS b
UNNEST b.details AS c
WHERE a.type="results" AND ((a.startTime <= 1462042800000 AND a.endTime >= 1462042800000)
OR (a.startTime >= 1462042800000 AND a.startTime <= 1462043025018))
AND (c.timeStamp BETWEEN 1462042800000 AND 1462043025018)
GROUP BY b.name) AS d;
Based of ndetails > offset+limit you have more entries then issue new query for that unique tag.