# Pastebin HNLBpSrs
SELECT year, month, day, hour, COUNT(*) AS events
FROM tbayer.popups
WHERE year = 2017 AND month = 11 AND day = 15
GROUP BY year, month, day, hour
ORDER BY year, month, day, hour LIMIT 10000;
      
year	month	day	hour	events
2017	11	15	0	465763
2017	11	15	1	454187
2017	11	15	2	450779
2017	11	15	3	440165
2017	11	15	4	417929
2017	11	15	5	415015
2017	11	15	6	440028
2017	11	15	7	520031
2017	11	15	8	595389
2017	11	15	9	694556
2017	11	15	10	728570
2017	11	15	11	729799
2017	11	15	12	751313
2017	11	15	13	847298
2017	11	15	14	935783
2017	11	15	15	951959
2017	11	15	16	946449
2017	11	15	17	886915
2017	11	15	18	861883
2017	11	15	19	662504
2017	11	15	20	28180
2017	11	15	21	13499
2017	11	15	22	8245
2017	11	15	23	4418
24 rows selected (114.25 seconds)