title: How to do looping on date and Time
body: <p>I want apply looping for every hour over week of data, lets say start date will be  <code>1/04/2019 00:00:00</code> and end date will be <code>8/04/2019 00:00:00</code> for querying to get data from bigquery.</p>
  
  <pre><code>sql_machine1 &lt;- "SELECT * FROM `lasprod2.iot_data` WHERE customer = \"client_name\" and asset = \"machine1\" and timestamp between \"01/04/2019 00:00:00\" and \"01/04/2019 01:00:00\""
  
  query_machine1 &lt;- bq_project_query(x = project,query = sql_machine1)
  machine1 &lt;- bq_table_download(query_machine1)
  </code></pre>
  
  <p>Looping should support below o/p format</p>
  
  <p>output format:</p>
  
  <p><a href="https://i.stack.imgur.com/tFoEi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tFoEi.png" alt="enter image description here"></a></p>