SELECT min(timestamp) + (max(timestamp) - epoch()) / 2 AS t2