Won't work either, because the data returned in each column differs when you change the WHERE clause, so the UNION creates multiple groups for each timestamp.

If I then went one step further and created a virtual table using unions and grouped the results of that data, it would be severely skewed, as it would add columns that it's selected twice, so I'm not sure that UNION is the answer here.