title: BigQuery - A way to generate timestamps based on hour/minute/seconds?
body: <p>Is there a way to generate sequential timestamps in BigQuery that is focused on hours, minutes, and seconds?</p>
  
  <p>In BigQuery you can generate sequential dates by:</p>
  
  <pre><code>select *
  FROM UNNEST(GENERATE_DATE_ARRAY('2016-10-18', '2016-10-19', INTERVAL 1 DAY)) as day
  </code></pre>
  
  <p>This will generate the dates from 2016-10-18 to 2016-10-19 in date intervals</p>
  
  <hr>
  
  <pre><code>Row day  
  1   2016-10-18   
  2   2016-10-19
  </code></pre>
  
  <hr>
  
  <p>But let's say I want intervals in 15 minutes or 5 minutes, is there a way to do that?</p>