title: How do I collapse the same rows between a date/time range?
body: <p>I want to collapse rows with the same URL parameter. This is my current query: </p>
  
  <pre><code>SELECT ADDTIME(date,time) as fecha, bytes, url FROM traffic;
  </code></pre>
  
  <p>And this is the result:</p>
  
  <pre><code>2014-07-07 09:05:56         14K     http://feeds.feedburner.com 
  2014-07-07 09:05:56         14K     http://feeds.feedburner.com 
  2014-07-07 09:11:56         14K     http://feeds.feedburner.com 
  2014-07-07 09:17:37         350K    http://www.cmmail.com   
  2014-07-07 09:17:40         5K      http://www.cmmail.com   
  2014-07-07 09:17:40         10K     http://www.cmmail.com   
  2014-07-07 09:20:26         1K      http://www.google.com   
  2014-07-07 09:20:48         1K      http://www.google.com   
  2014-07-07 09:20:49         1K      http://www.cronista.com 
  2014-07-07 09:20:49         1K      http://www.cronista.com 
  </code></pre>
  
  <p>What I want is to group the same URL between each 5 minute interval, and sum <code>bytes</code>. In other words, I want this result:</p>
  
  <pre><code>2014-07-07 09:05:00         28K     http://feeds.feedburner.com 
  2014-07-07 09:10:00         14K     http://feeds.feedburner.com 
  2014-07-07 09:15:00         365K    http://www.cmmail.com   
  2014-07-07 09:20:00         2K      http://www.google.com   
  2014-07-07 09:20:00         2K      http://www.cronista.com 
  </code></pre>