rendered paste body+---------------------+---------------+-------------------+-----------------------+----------------------------------+
| tag | SUM(imps) | SUM(pred_value) | SUM(actual_value) | SUM(actual_value)/SUM(imps)*1000 |
+---------------------+---------------+-------------------+-----------------------+----------------------------------+
| 2007-12-20_10:22:05 | 4701 | 1.6688832217 | 0.823453094999999 | 0.1751655169113 |
| 2007-12-20_11:10:12 | 3290 | 1.2381726227 | 0.6971916826 | 0.21191236553191 |
| 2007-12-21_11:44:31 | 4355 | 1.5961365027 | 0.754693492299999 | 0.17329356884041 |
| 2007-12-21_12:04:36 | 4465 | 1.5839513241 | 0.817380361799999 | 0.18306391081747 |
| 2007-12-21_12:24:48 | 4822 | 1.7256364141 | 0.854747543899999 | 0.17725996347988 |
| 2007-12-21_12:44:50 | 4786 | 1.6809019915 | 0.899532985399999 | 0.18795089540326 |
| 2007-12-21_13:04:52 | 2842 | 1.2256811335 | 0.5681370421 | 0.19990747434905 |
| 2007-12-21_13:24:59 | 4279 | 1.5919216904 | 0.759473791299999 | 0.17748861680299 |
| 2007-12-21_13:44:46 | 4355 | 1.5456264294 | 0.7626968165 | 0.17513130114811 |
| 2007-12-21_17:33:57 | 4311 | 1.5809744014 | 0.761798648199999 | 0.17671042639759 |
| 2007-12-21_17:54:03 | 4856 | 1.6838366956 | 0.855827692599999 | 0.17624128760297 |
| 2007-12-21_18:14:05 | 4815 | 1.7468464011 | 0.772619840799999 | 0.16046102612669 |
| 2007-12-21_18:33:58 | 4856 | 1.6057545178 | 0.832339972599999 | 0.17140444246293 |
| 2007-12-21_18:53:59 | 4815 | 1.733311666 | 0.798180732599999 | 0.16576962255452 |
| 2007-12-21_19:14:03 | 4769 | 1.6592169913 | 0.853722828799999 | 0.17901506160621 |
| 2007-12-21_19:33:48 | 4779 | 1.7253443888 | 0.794752460799998 | 0.16630099619167 |
| 2007-12-21_19:53:43 | 3347 | 1.3473452298 | 0.667398195 | 0.19940191066627 |
| 2007-12-21_20:13:51 | 4343 | 1.5471772711 | 0.740365766999999 | 0.17047335183053 |
| 2007-12-21_20:33:55 | 4313 | 1.5858408539 | 0.740169908199999 | 0.17161370466033 |
| 2007-12-21_20:53:51 | 4911 | 1.7260581109 | 0.856376084999998 | 0.1743791661576 |
| 2007-12-21_21:13:43 | 4411 | 1.6042534615 | 0.762616190799999 | 0.17288963745182 |
| 2007-12-21_21:33:42 | 4323 | 1.5894353709 | 0.696565719999999 | 0.16113016886421 |
| 2007-12-21_21:53:36 | 4815 | 1.68830758 | 0.809484172599998 | 0.1681171698027 |
| 2007-12-21_22:13:38 | 2428 | 1.1103563481 | 0.51233295 | 0.21101027594728 |
| 2007-12-21_22:33:07 | 4786 | 1.6818712887 | 0.793557872399998 | 0.16580816389469 |
| 2007-12-21_22:53:00 | 4758 | 1.6819713546 | 0.760863983799998 | 0.15991256490122 |
| 2007-12-21_23:13:03 | 4728 | 1.590365277 | 0.819828870799998 | 0.17339866133672 |
| 2007-12-21_23:33:03 | 4256 | 1.5224441003 | 0.664436522599999 | 0.15611760399436 |
| 2007-12-21_23:53:03 | 4787 | 1.6849600125 | 0.832427794999998 | 0.1738934186338 |
| 2007-12-22_00:13:05 | 4823 | 1.72993864699999 | 0.815873010799999 | 0.16916297134564 |
| 2007-12-22_00:33:06 | 2742 | 1.0795606331 | 0.438422970000001 | 0.15989167396061 |
| 2007-12-22_00:53:04 | 4701 | 1.6506729504 | 0.805682096199998 | 0.17138525764731 |
| 2007-12-22_01:13:04 | 4227 | 1.5050906661 | 0.703363485599999 | 0.16639779645138 |
| 2007-12-22_01:33:03 | 4783 | 1.6185102271 | 0.837012806199998 | 0.17499745059586 |
| 2007-12-22_01:53:03 | 4230 | 1.5166792177 | 0.730680625599999 | 0.17273773654846 |
| 2007-12-22_02:12:55 | 4187 | 1.4807629229 | 0.749818473899999 | 0.17908251108192 |
| 2007-12-22_02:32:52 | 2849 | 1.228630997 | 0.56207615 | 0.19728892593893 |
| 2007-12-22_02:52:09 | 3391 | 1.3015816548 | 0.6305474526 | 0.18594734668239 |
| 2007-12-22_03:12:04 | 4745 | 1.5668584904 | 0.820872619999998 | 0.17299739093783 |
| 2007-12-22_03:32:03 | 4749 | 1.6197025024 | 0.825179339999998 | 0.17375854706254 |
| 2007-12-22_03:52:03 | 4660 | 1.5176236766 | 0.823364901999998 | 0.1766877472103 |
| 2007-12-22_04:12:05 | 4749 | 1.6002595885 | 0.795052841999998 | 0.16741479090335 |
| 2007-12-22_04:32:04 | 4745 | 1.5684417164 | 0.836019784399998 | 0.17618962790306 |
| 2007-12-22_04:51:58 | 4741 | 1.6494356432 | 0.843677161999998 | 0.17795341953174 |
| 2007-12-22_05:12:00 | 4735 | 1.6498366178 | 0.830201364399998 | 0.17533291750792 |
| 2007-12-22_05:32:06 | 4664 | 1.6691994426 | 0.838177131999998 | 0.1797120780446 |
| 2007-12-22_05:52:04 | 4743 | 1.6034640751 | 0.846687051999998 | 0.17851297744044 |
| 2007-12-22_06:12:04 | 7377 | 2.3455327505 | 1.07355197379999 | 0.14552690440558 |
| 2007-12-22_06:31:49 | 5230 | 1.7683013699 | 0.900284202399998 | 0.17213847082218 |
| 2007-12-22_06:51:50 | 2861 | 1.1227076618 | 0.5689284126 | 0.198856488151 |
| 2007-12-22_07:11:38 | 4926 | 1.6514093837 | 0.816832718799998 | 0.16582068997158 |
| 2007-12-22_07:31:06 | 4144 | 1.505577882 | 0.726528434999999 | 0.17532056829151 |
| 2007-12-22_07:51:04 | 4167 | 1.4209813115 | 0.747981902599998 | 0.17950129652028 |
| 2007-12-22_08:11:04 | 4354 | 1.5254431657 | 0.773158152599998 | 0.17757421970602 |
| 2007-12-22_08:31:05 | 4116 | 1.5171268099 | 0.809165792599998 | 0.19659032862002 |
| 2007-12-22_08:51:04 | 4312 | 1.5440711332 | 0.803010072599999 | 0.18622682574211 |
| 2007-12-22_09:11:04 | 3738 | 1.3986519033 | 0.647172529999999 | 0.17313336811129 |
| 2007-12-22_09:31:04 | 3689 | 1.3648507656 | 0.708783539999999 | 0.19213432908647 |
| 2007-12-22_09:51:04 | 4124 | 1.4561410859 | 0.756744372599999 | 0.18349766551891 |
| 2007-12-22_10:11:03 | 3877 | 1.4317260511 | 0.753144842599999 | 0.19425969631158 |
| 2007-12-22_10:31:03 | 2776 | 1.1102869144 | 0.572505287 | 0.20623389301153 |
| 2007-12-22_10:50:45 | 3324 | 1.2552934666 | 0.679496742599999 | 0.20442140270758 |
| 2007-12-22_11:10:43 | 3163 | 1.2011065822 | 0.62964 | 0.19906417957635 |
| 2007-12-22_11:30:46 | 3045 | 1.2694949834 | 0.57074002 | 0.18743514614121 |
| 2007-12-22_11:50:46 | 2036 | 0.5537162763 | 0.346609405 | 0.17024037573674 |
| 2007-12-22_12:10:51 | 3781 | 1.3847493256 | 0.6901396026 | 0.18252832652737 |
| 2007-12-22_12:30:54 | 2864 | 1.1857649929 | 0.5345885 | 0.18665799581006 |
| 2007-12-22_12:50:55 | 1805 | 0.7853616042 | 0.36684046 | 0.20323571191136 |
| 2007-12-22_13:10:54 | 3244 | 1.249458603 | 0.6337004424 | 0.1953453891492 |
| 2007-12-22_13:30:57 | 3957 | 1.4456669137 | 0.714614272599999 | 0.18059496401314 |
| 2007-12-22_13:50:57 | 3234 | 1.290113068 | 0.6309647424 | 0.19510350723562 |
| 2007-12-22_14:10:50 | 3742 | 1.3210621799 | 0.764782664999999 | 0.20437805050775 |
| 2007-12-22_14:30:51 | 3497 | 1.351964234 | 0.667151602599999 | 0.19077826782957 |
| 2007-12-22_14:50:44 | 3160 | 1.1674600493 | 0.675828186999999 | 0.21386967943038 |
| 2007-12-22_15:10:48 | 2779 | 1.1672319373 | 0.5495348224 | 0.19774552803167 |
| 2007-12-22_15:30:38 | 2812 | 1.2151252903 | 0.60198316 | 0.21407651493599 |
| 2007-12-22_15:50:35 | 3361 | 1.3067692306 | 0.6688475226 | 0.19900253573341 |
| 2007-12-22_16:10:38 | 2792 | 1.1867893684 | 0.5703158124 | 0.20426784111748 |
| 2007-12-22_16:30:14 | 3332 | 1.2367136397 | 0.6485792426 | 0.19465163343337 |
| 2007-12-22_16:50:06 | 2805 | 1.1085182823 | 0.6079914224 | 0.21675273525847 |
| 2007-12-22_17:10:04 | 2770 | 1.141968263 | 0.58148722 | 0.20992318411552 |
| 2007-12-22_17:30:03 | 3294 | 1.259281393 | 0.6617042826 | 0.20088168870674 |
| 2007-12-22_17:49:54 | 3264 | 1.2307931744 | 0.6268599826 | 0.19205269074755 |
| 2007-12-22_18:09:48 | 3363 | 1.1831435636 | 0.6084186926 | 0.18091546018436 |
| 2007-12-22_18:29:52 | 2794 | 1.0618393982 | 0.545155947 | 0.19511665962777 |
| 2007-12-22_18:49:59 | 3310 | 1.2433598905 | 0.6517977426 | 0.19691774700906 |
| 2007-12-22_19:10:03 | 2847 | 1.0844747358 | 0.539000825 | 0.1893223832104 |
| 2007-12-22_19:29:56 | 3306 | 1.1884777035 | 0.6039790926 | 0.18269180054446 |
| 2007-12-22_19:49:58 | 3281 | 1.2216927938 | 0.653208245 | 0.19908815757391 |
| 2007-12-22_20:10:00 | 2855 | 1.1766691605 | 0.5589350326 | 0.19577409197898 |
| 2007-12-22_20:29:58 | 3298 | 1.2120913418 | 0.6271094426 | 0.19014840588235 |
| 2007-12-22_20:49:59 | 2830 | 1.0671896298 | 0.5468193226 | 0.19322237547703 |
| 2007-12-22_21:09:59 | 3302 | 1.1891646182 | 0.6758615338 | 0.20468247540884 |
| 2007-12-22_21:30:07 | 3308 | 1.2897304839 | 0.663953614999999 | 0.20071149183797 |
| 2007-12-22_21:49:57 | 3327 | 1.2803500772 | 0.6255154526 | 0.18801185831079 |
| 2007-12-22_22:10:00 | 3301 | 1.2335663307 | 0.664006915 | 0.20115326113299 |
| 2007-12-22_22:30:07 | 2804 | 1.0822871188 | 0.6310380824 | 0.22504924479315 |
| 2007-12-22_22:50:08 | 2780 | 1.0970087588 | 0.59990612 | 0.21579356834532 |
| 2007-12-22_23:10:07 | 5223 | 1.6963832285 | 1.009944794 | 0.19336488493203 |
| 2007-12-22_23:30:00 | 3280 | 1.2636370276 | 0.6428672626 | 0.19599611664634 |
| 2007-12-22_23:49:56 | 3286 | 1.2293062351 | 0.6447141026 | 0.19620027468046 |
| 2007-12-23_00:10:01 | 3272 | 1.2584359343 | 0.598539102600001 | 0.18292759859413 |
| 2007-12-23_00:30:06 | 3269 | 1.1530122226 | 0.6197952396 | 0.18959780960538 |
| 2007-12-23_00:50:00 | 3304 | 1.2835948078 | 0.6732180726 | 0.20375849654964 |
| 2007-12-23_01:10:04 | 3329 | 1.3036741765 | 0.6590907668 | 0.19798461003304 |
| 2007-12-23_01:30:04 | 3282 | 1.1774386965 | 0.6361055326 | 0.19381643284583 |
| 2007-12-23_01:50:07 | 2806 | 1.150375934 | 0.5767890224 | 0.20555560313614 |
| 2007-12-23_02:10:06 | 2770 | 1.137522931 | 0.56918505 | 0.20548196750903 |
| 2007-12-23_02:30:01 | 1736 | 0.6940309941 | 0.3647387624 | 0.21010297373272 |
| 2007-12-23_02:49:57 | 3296 | 1.1912189007 | 0.643812512599999 | 0.19533146620146 |
| 2007-12-23_03:09:52 | 3279 | 1.2317414622 | 0.628829205 | 0.19177468892955 |
| 2007-12-23_10:44:57 | 4772 | 1.7079938741 | 0.864728693899999 | 0.18120886292959 |
| 2007-12-23_11:04:52 | 4829 | 1.7017795731 | 0.861292670799999 | 0.17835839113688 |
| 2007-12-23_11:24:52 | 4840 | 1.691548321 | 0.884571622099999 | 0.18276273183884 |
| 2007-12-23_11:44:48 | 4332 | 1.5815832591 | 0.767363454499999 | 0.17713837823176 |
| 2007-12-23_12:04:51 | 4845 | 1.673527443 | 0.861499587099999 | 0.1778120922807 |
| 2007-12-23_12:24:56 | 3321 | 1.0361144263 | 0.566917645000001 | 0.17070690906354 |
| 2007-12-23_12:44:59 | 3311 | 1.1447293939 | 0.588837009500001 | 0.17784264859559 |
| 2007-12-23_13:04:53 | 4867 | 1.6733979384 | 0.892184567099999 | 0.18331304029176 |
| 2007-12-23_13:25:05 | 4832 | 1.6179957419 | 0.843389783899999 | 0.17454258772765 |
| 2007-12-23_13:45:05 | 4863 | 1.6021203506 | 0.880761069599999 | 0.18111475829735 |
| 2007-12-23_14:05:04 | 4804 | 1.667746943 | 0.855523052099999 | 0.17808556455037 |
| 2007-12-23_14:25:04 | 3540 | 1.3731636496 | 0.6231564624 | 0.17603289898305 |
| 2007-12-23_14:45:05 | 4315 | 1.5204088421 | 0.726723161299999 | 0.16841788210892 |
| 2007-12-23_15:04:58 | 4405 | 1.609327259 | 0.780295833699999 | 0.17713866826334 |
| 2007-12-23_15:24:50 | 4452 | 1.5608457108 | 0.800903312599999 | 0.17989741972147 |
| 2007-12-23_15:44:55 | 3280 | 1.2976244469 | 0.6586784063 | 0.20081658728659 |
| 2007-12-23_16:04:56 | 4814 | 1.6146385421 | 0.878139673899999 | 0.18241372536352 |
| 2007-12-23_16:24:56 | 4823 | 1.6981982463 | 0.845297061799999 | 0.17526374907734 |
| 2007-12-23_16:44:57 | 4805 | 1.6384430735 | 0.861638882899999 | 0.17932130757544 |
| 2007-12-23_17:04:49 | 4783 | 1.6052950892 | 0.873205951199999 | 0.18256448906544 |
| 2007-12-23_17:24:52 | 4371 | 1.5974390816 | 0.810621971299999 | 0.18545458048501 |
| 2007-12-23_17:44:43 | 4892 | 1.7386212442 | 0.856838812099999 | 0.17515102455029 |
| 2007-12-23_18:04:39 | 1945257447841 | 1.7817847768 | 1.15698567324262e+308 | 5.9477251945584e+298 |
| 2007-12-23_18:24:42 | 2823 | 1.1226797677 | 0.61433613 | 0.21761818278427 |
| 2007-12-23_18:44:37 | 3900 | 1.4478472895 | 0.706854079499999 | 0.18124463576923 |
| 2007-12-23_19:04:04 | 4775 | 1.7377083652 | 0.828387052899999 | 0.17348419956021 |
| 2007-12-23_19:24:04 | 4834 | 1.7253681013 | 0.8215995608 | 0.16996267290029 |
| 2007-12-23_19:43:57 | 4810 | 1.6768868874 | 0.928770500799998 | 0.1930915802079 |
| 2007-12-23_20:03:48 | 3942 | 1.4608465566 | 0.619091212399999 | 0.15705002851344 |
| 2007-12-23_20:23:52 | 4206 | 1.489501246 | 0.727163919499999 | 0.17288728471232 |
| 2007-12-23_20:43:36 | 4262 | 1.5881756168 | 0.690942809999999 | 0.16211703660253 |
| 2007-12-23_21:03:35 | 4828 | 1.680721533 | 0.842778363199998 | 0.17456055575808 |
| 2007-12-23_21:23:36 | 4865 | 1.5993959143 | 0.815979867799998 | 0.16772453603289 |
| 2007-12-23_21:43:35 | 4824 | 1.6735164904 | 0.852533854999998 | 0.17672758188226 |
| 2007-12-23_22:03:35 | 4377 | 1.5835340397 | 0.737932019999999 | 0.16859310486635 |
| 2007-12-23_22:23:36 | 4739 | 1.6013451102 | 0.818519528199999 | 0.17271988356193 |
| 2007-12-23_22:43:03 | 4731 | 1.6754343976 | 0.830222500599998 | 0.17548562684422 |
| 2007-12-23_23:02:48 | 4670 | 1.6163348382 | 0.836859664999998 | 0.17919907173448 |
| 2007-12-23_23:22:49 | 2734 | 1.01049066 | 0.441024655600001 | 0.16131113957571 |
| 2007-12-23_23:42:51 | 4163 | 1.5011561935 | 0.686919515599999 | 0.16500588892625 |
| 2007-12-24_00:02:52 | 4412 | 1.6068394249 | 0.762857102599998 | 0.1729050549864 |
| 2007-12-24_00:23:00 | 4288 | 1.5038097964 | 0.697084765599999 | 0.16256640988806 |
| 2007-12-24_00:43:03 | 4206 | 1.5067034152 | 0.696096985599999 | 0.16550094759867 |
| 2007-12-24_01:02:58 | 4224 | 1.5018477437 | 0.701750775599999 | 0.16613417982955 |
| 2007-12-24_01:22:55 | 3176 | 1.1830398521 | 0.4813065556 | 0.15154488526448 |
| 2007-12-24_01:42:56 | 4172 | 1.4792371211 | 0.728202645599998 | 0.17454521706615 |
| 2007-12-24_02:02:56 | 2419 | 1.0116402921 | 0.5177506624 | 0.21403499892518 |
| 2007-12-24_02:22:56 | 4757 | 1.5667056255 | 0.822160620599999 | 0.17283174702544 |
| 2007-12-24_02:43:01 | 4728 | 1.5612470384 | 0.803338810599999 | 0.16991091594755 |
| 2007-12-24_03:03:03 | 4774 | 1.6421361483 | 0.759224718199998 | 0.1590332463762 |
| 2007-12-24_03:23:04 | 4734 | 1.6520554623 | 0.821123752399998 | 0.1734524191804 |
| 2007-12-24_03:43:04 | 4714 | 1.6726232564 | 0.783980588199999 | 0.16630899198133 |
| 2007-12-24_04:03:05 | 4804 | 1.6589445106 | 0.785461088199998 | 0.16350147547877 |
| 2007-12-24_04:23:04 | 4792 | 1.6225503371 | 0.796892086399998 | 0.16629634524207 |
| 2007-12-24_04:43:04 | 4713 | 1.5743136645 | 0.781221366199998 | 0.16575883008699 |
| 2007-12-24_05:03:04 | 4391 | 1.5450209413 | 0.789211842599999 | 0.17973396552038 |
| 2007-12-24_05:23:03 | 4780 | 1.5957027115 | 0.855912204999998 | 0.17906113075314 |
| 2007-12-24_05:43:04 | 4727 | 1.6214410071 | 0.777306280799998 | 0.16443966168817 |
| 2007-12-24_06:03:05 | 4768 | 1.6500521567 | 0.780144432599999 | 0.16362089609899 |
| 2007-12-24_06:23:03 | 4740 | 1.5819778261 | 0.842496738199998 | 0.1777419278903 |
| 2007-12-24_06:43:04 | 4741 | 1.6090369549 | 0.815539293799999 | 0.172018412529 |
| 2007-12-24_07:02:50 | 4229 | 1.5212727995 | 0.712101655599999 | 0.16838535247103 |
| 2007-12-24_07:22:56 | 2407 | 1.0034102698 | 0.38429692 | 0.15965804736186 |
| 2007-12-24_07:42:59 | 4224 | 1.5557379489 | 0.744536687999999 | 0.17626342045455 |
| 2007-12-24_08:03:01 | 4187 | 1.580932699 | 0.690525723599999 | 0.16492135743969 |
| 2007-12-24_08:22:56 | 4224 | 1.5902258895 | 0.679168905599999 | 0.16078809318182 |
| 2007-12-24_08:42:55 | 4677 | 1.5794885614 | 0.840321624999998 | 0.17967107654479 |
| 2007-12-24_09:02:47 | 111996243251 | 0.914273677300001 | 8.02989130579301e+283 | 7.1697863005966e+275 |
| 2007-12-24_09:22:40 | 4735 | 1.5655829541 | 0.905117662599998 | 0.19115473338965 |
| 2007-12-24_09:42:46 | 4682 | 1.59882513 | 0.800233273799999 | 0.17091697432721 |
| 2007-12-24_10:03:04 | 4734 | 1.6555125877 | 0.812949808199998 | 0.17172577275032 |
| 2007-12-24_10:23:03 | 4203 | 1.5529165275 | 0.729856825399999 | 0.17365139790626 |
| 2007-12-24_13:02:50 | 4790 | 1.6531887766 | 0.803910318199999 | 0.16783096413361 |