title: Python Count number of records within a given date range
body: <p>We have a backend table that stores details of transaction including seconds since epoch. I am creating a UI where I collect from-to dates to display counts of transaction occurred in-between the dates.</p>
  
  <p>Assuming that the date range is from 07/01/2012 - 07/30/2012, I am unable to establish a logic that will increment a counter for records that happened within the time period. I should hit the DB only once as hitting for each day will give poor performance.</p>
  
  <p>I am stuck at a logic:</p>
  
  <pre><code>Convert 07/01/2012 &amp; 07/30/2012 to seconds since epoch.
  Get the records for start date - end date [as converted to seconds since epoch] 
     For each record get the month / date 
       -- now how will we add counters for each date in between 07/01/2012 - 07/30/2012 
  </code></pre>