Controller:

    @hourly_views = View.views_each_hour

Model:

  def self.views_each_hour
    find_by_sql("SELECT COUNT(*) c, COUNT(DISTINCT(remote_addr)) d, DATE_FORMAT(time_visited, '%H') f FROM views GROUP BY f")
  end

View:

<%= render :partial => 'hourly', :locals => { :views => @hourly_views } %>

Partial:

<h2>Hour Breakdown</h2>

<table>
<tr>
  <th>Hour</th>
  <th>Uniques/Views</th>
</tr>
<% for view in @views %>
<tr>
  <td><%= view.f %></td>
  <td><b><%= view.d %></b> U <b><%= view.c %></b> V</td>
</tr>
<% end %>
</table>