sql>select * from interfaces where host='gw61' and ts > '2013-09-11 23:00:14.000000' and ts <= '2013-09-12 01:05:14.000000' order by ts;
+----------------------------+------+--------+------------+---------+-----------+------------+-------------+---------+---------+------------+
| ts                         | host | dev    | rx_bytes   | rx_errs | rx_drop   | rx_packets | tx_bytes    | tx_errs | tx_drop | tx_packets |
+============================+======+========+============+=========+===========+============+=============+=========+=========+============+
| 2013-09-11 23:00:19.000000 | gw61 | vnet11 |      63697 |       0 |         0 |        294 |  3236152008 |       0 |       0 |    2242774 |
| 2013-09-11 23:00:49.000000 | gw61 | vnet11 |      32306 |       0 |         0 |        264 |  3368560032 |       0 |       0 |    2334534 |
| 2013-09-11 23:01:19.000000 | gw61 | vnet11 |      25136 |       0 |         0 |        229 |  4237274996 |       0 |       0 |    2936552 |
| 2013-09-11 23:01:50.000000 | gw61 | vnet11 |      66120 |       0 |         0 |        309 |  3712187856 |       0 |       0 |    2572671 |
| 2013-09-11 23:02:20.000000 | gw61 | vnet11 |      69687 |       0 |         0 |        326 |  3345923475 |       0 |       0 |    2318846 |
| 2013-09-11 23:02:50.000000 | gw61 | vnet11 |      63560 |       0 |         0 |        320 |  3138954415 |       0 |       0 |    2175416 |
| 2013-09-11 23:03:21.000000 | gw61 | vnet11 |      57009 |       0 |         0 |        296 |  3265148953 |       0 |       0 |    2262871 |
| 2013-09-11 23:03:51.000000 | gw61 | vnet11 |      48007 |       0 |         0 |        298 |  4147244668 |       0 |       0 |    2874159 |
| 2013-09-11 23:04:21.000000 | gw61 | vnet11 |      71967 |       0 |         0 |        317 |  3609208168 |       0 |       0 |    2501306 |
| 2013-09-11 23:04:52.000000 | gw61 | vnet11 |      61586 |       0 |         0 |        295 |  3279701321 |       0 |       0 |    2272952 |
| 2013-09-11 23:05:22.000000 | gw61 | vnet11 |      57831 |       0 |         0 |        302 |  3228970425 |       0 |       0 |    2237801 |
| 2013-09-11 23:05:53.000000 | gw61 | vnet11 |      60548 |       0 |         0 |        295 |  3238573141 |       0 |       0 |    2244453 |
| 2013-09-11 23:06:23.000000 | gw61 | vnet11 |      29824 |       0 |         0 |        290 |  4212621656 |       0 |       0 |    2919471 |
| 2013-09-11 23:06:53.000000 | gw61 | vnet11 |      55462 |       0 |         0 |        299 |  3544989777 |       0 |       0 |    2456799 |
| 2013-09-11 23:07:24.000000 | gw61 | vnet11 |      95397 |       0 |         0 |        472 |  3310254429 |       0 |       0 |    2294128 |
| 2013-09-11 23:07:54.000000 | gw61 | vnet11 |      55412 |       0 |         0 |        289 |  3313030506 |       0 |       0 |    2296052 |
| 2013-09-11 23:08:25.000000 | gw61 | vnet11 |      76795 |       0 |         0 |        326 |  3348312096 |       0 |       0 |    2320501 |
| 2013-09-11 23:08:55.000000 | gw61 | vnet11 |      26009 |       0 |         0 |        246 |  4364885275 |       0 |       0 |    3024986 |
| 2013-09-11 23:09:25.000000 | gw61 | vnet11 |      69769 |       0 |         0 |        324 |  3263828483 |       0 |       0 |    2261955 |
| 2013-09-11 23:09:56.000000 | gw61 | vnet11 |      70600 |       0 |         0 |        322 |  3278146169 |       0 |       0 |    2271867 |
| 2013-09-11 23:10:26.000000 | gw61 | vnet11 |      53935 |       0 |         0 |        298 |  3250974351 |       0 |       0 |    2253048 |
| 2013-09-11 23:10:56.000000 | gw61 | vnet11 |   18080963 |       0 |    617722 |     311502 |  3078514635 |       0 |       0 |    2430831 |
| 2013-09-11 23:11:27.000000 | gw61 | vnet11 |   56008223 |       0 |   1832308 |     965407 |    55735764 |       0 |       0 |     960887 |
| 2013-09-11 23:11:57.000000 | gw61 | vnet11 |   53546195 |       0 |   1861948 |     923008 |    53303596 |       0 |       0 |     919028 |
| 2013-09-11 23:12:27.000000 | gw61 | vnet11 |   51867481 |       0 |   1830176 |     894051 |    51562532 |       0 |       0 |     889010 |
| 2013-09-11 23:12:58.000000 | gw61 | vnet11 |   51416780 |       0 |   1845160 |     886282 |    51098232 |       0 |       0 |     881006 |
| 2013-09-11 23:13:28.000000 | gw61 | vnet11 |   52806942 |       0 |   1813146 |     910234 |    52581560 |       0 |       0 |     906580 |
| 2013-09-11 23:13:58.000000 | gw61 | vnet11 |   54330309 |       0 |   1792436 |     936568 |    47571364 |       0 |       0 |     820191 |
| 2013-09-11 23:14:29.000000 | gw61 | vnet11 |   52275802 |       0 |   1848039 |     901033 |    51853210 |       0 |       0 |     894018 |
| 2013-09-11 23:14:59.000000 | gw61 | vnet11 |   58522522 |       0 |   1701003 |    1008789 |    45447546 |       0 |       0 |     783579 |
| 2013-09-11 23:15:29.000000 | gw61 | vnet11 |   55923970 |       0 |   1799848 |     963976 |    55682747 |       0 |       0 |     960044 |
| 2013-09-11 23:16:00.000000 | gw61 | vnet11 |   58354544 |       0 |   1799736 |    1005858 |    58088226 |       0 |       0 |    1001518 |
| 2013-09-11 23:16:30.000000 | gw61 | vnet11 |   52382175 |       0 |   1916470 |     902919 |    52179461 |       0 |       0 |     899637 |
| 2013-09-11 23:17:00.000000 | gw61 | vnet11 |   54910580 |       0 |   1793476 |     946502 |    54690885 |       0 |       0 |     942944 |
| 2013-09-11 23:17:31.000000 | gw61 | vnet11 |   49589582 |       0 |   1919071 |     854782 |    49403361 |       0 |       0 |     851771 |
| 2013-09-11 23:18:01.000000 | gw61 | vnet11 |   55298095 |       0 |   1837113 |     953191 |    54919414 |       0 |       0 |     946872 |
| 2013-09-11 23:18:32.000000 | gw61 | vnet11 |   39418114 |       0 |   1981024 |     679600 |    39460643 |       0 |       0 |     680298 |
| 2013-09-11 23:19:02.000000 | gw61 | vnet11 |   27881936 |       0 |   1037428 |     479554 |    27572654 |       0 |       0 |     475382 |
| 2013-09-11 23:19:32.000000 | gw61 | vnet11 |   46176649 |       0 |   1531644 |     795436 |    46019938 |       0 |       0 |     793447 |
| 2013-09-11 23:20:03.000000 | gw61 | vnet11 |   25247998 |       0 |   1019560 |     432337 |    22616814 |       0 |       0 |     389936 |
| 2013-09-11 23:20:33.000000 | gw61 | vnet11 |   50426638 |       0 |   1775337 |     869401 |    50482994 |       0 |       0 |     870397 |
| 2013-09-11 23:31:48.000000 | gw61 | vnet11 |  996176702 |       0 |  33010541 |   17147688 |   946685731 |       0 |       0 |   16322084 |
| 2013-09-11 23:32:35.000000 | gw61 | vnet11 |   58167300 |       0 |   1718130 |    1000003 |    50362226 |       0 |       0 |     868319 |
| 2013-09-11 23:47:07.000000 | gw61 | vnet11 | 1323149221 |       0 |  42855029 |   22767697 |  1282603964 |       0 |       0 |   22113787 |
| 2013-09-11 23:47:37.000000 | gw61 | vnet11 |   25910263 |       0 |    704863 |     443141 |    24667003 |       0 |       0 |     425289 |
| 2013-09-11 23:48:08.000000 | gw61 | vnet11 |   53633821 |       0 |   1853428 |     924682 |    51526728 |       0 |       0 |     888394 |
| 2013-09-12 00:52:30.000000 | gw61 | vnet11 | 1209838140 |       0 |  34849285 |   20825311 |  1136628101 |       0 |       0 |   19596959 |
| 2013-09-12 00:53:14.000000 | gw61 | vnet11 | 4334196995 |       0 | 158475016 |   74635428 | 11056478214 |       0 |       0 |   76817380 |
| 2013-09-12 00:53:45.000000 | gw61 | vnet11 |      28324 |       0 |         0 |        272 |  3673681939 |       0 |       0 |    2546307 |
| 2013-09-12 01:04:02.000000 | gw61 | vnet11 |    1468619 |       0 |         0 |      10776 | 35609961249 |       0 |       0 |   24680205 |
| 2013-09-12 01:04:33.000000 | gw61 | vnet11 |      24917 |       0 |         0 |        235 |       29732 |       0 |       0 |        140 |
| 2013-09-12 01:05:03.000000 | gw61 | vnet11 |      23498 |       0 |         0 |        221 |       30698 |       0 |       0 |        139 |
+----------------------------+------+--------+------------+---------+-----------+------------+-------------+---------+---------+------------+
52 tuples (134.517ms)