Have you seen the Page View Statistics data that is available?
http://dumps.wikimedia.org/other/pagecounts-raw/
The page counts are not broken out by category, or country, but they
do include the project and language. So in theory you can do something
like this:
curl
http://dumps.wikimedia.org/other/pagecounts-raw/2013/2013-01/pagecounts-201…
| zcat - | egrep '^hi '
To see the Hindi Wikipedia page views for 2013-01-07 08:00. I say in
theory because the download server seems to be somewhat slow at the
moment (100K/s) so I didn't see it actually work :-)
//Ed