{"body":"SELECT year, month, day, hour, COUNT(*) AS events\nFROM tbayer.popups\nWHERE year = 2017 AND month = 11 AND day = 15\nGROUP BY year, month, day, hour\nORDER BY year, month, day, hour LIMIT 10000;\n      \nyear\tmonth\tday\thour\tevents\n2017\t11\t15\t0\t465763\n2017\t11\t15\t1\t454187\n2017\t11\t15\t2\t450779\n2017\t11\t15\t3\t440165\n2017\t11\t15\t4\t417929\n2017\t11\t15\t5\t415015\n2017\t11\t15\t6\t440028\n2017\t11\t15\t7\t520031\n2017\t11\t15\t8\t595389\n2017\t11\t15\t9\t694556\n2017\t11\t15\t10\t728570\n2017\t11\t15\t11\t729799\n2017\t11\t15\t12\t751313\n2017\t11\t15\t13\t847298\n2017\t11\t15\t14\t935783\n2017\t11\t15\t15\t951959\n2017\t11\t15\t16\t946449\n2017\t11\t15\t17\t886915\n2017\t11\t15\t18\t861883\n2017\t11\t15\t19\t662504\n2017\t11\t15\t20\t28180\n2017\t11\t15\t21\t13499\n2017\t11\t15\t22\t8245\n2017\t11\t15\t23\t4418\n24 rows selected (114.25 seconds)\n","name":"hourly event rates for Popups on 2017-11-15","extension":"txt","url":"https://www.irccloud.com/pastebin/HNLBpSrs/hourly+event+rates+for+Popups+on+2017-11-15","modified":1510826978,"id":"HNLBpSrs","size":748,"lines":32,"own_paste":false,"theme":"","date":1510826978}