I figured it out, this query gets total time spent by day:
SELECT visited_at, SUM(time_read * 60) AS total_user_secs FROM user_visits GROUP BY visited_at ORDER BY visited_at
Example in my forum:
