What I'm trying to achieve: for my www portals work, I want the results of aggregation (SELECT project, sum(view_count) AS num FROM projectview_hourly WHERE year=2015 AND month=11 AND day=3 GROUP BY project) published somewhere in a machine-readable format. Ideally, this could be published externally (for example, https://stats.wikimedia.org/daily_pageviews.csv or whatever). If that is hard, making it somehow available on the cluster would suffice. What are the options for doing that?

--