Generating a static page from a script

I don’t know how one would define “best”, but a possible approach would be to make your rankings page an actual page within WordPress, then add either a shortcode or a filter on the_content to populate/fetch a transient from the database. You could alternately save it in an option or as post meta and cron a script to update the option/meta periodically. WP CLI may be of interest to you as well.