Number 24- Fowler
Dexter Fowler was as a Rockie for six seasons and at least thus far, is the best player to wear #24.
He wore #24 for five of those seasons and in that time, he hit .271/.367/.427 with an OPS+ of 102. He also had a WAR of 9.8.
Ryan McMahon currently wears the numbers for the Rockies so if he spends the foreseeable future with the Rockies and reaches his full potential, in a few years, he might overtake Fowler on the list.
Number 25- Sweeney
You may be rather surprised that Mark Sweeney is the winner of this one but he is the only Rockies player to ever wear the uniform for more than 67 games (Seth Smith in 2008). The reason why that is the case is that #25 has been frequently been worn by Rockies coaches or managers.
Don Baylor wore #25 when he was the Rockies manager from 1993 through 1998 and again when he was the Rockies hitting coach in 2009 and 2010. Buddy Bell wore it during his managerial tenure and Rich Dauer and Blake Doyle wore it while they were on the Rockies coaching staff in the early 2010s.
Before Drew Butera wore the number in 2019, Smith was the last player to wear the number.
For Sweeney, as a Rockie, he was mainly a pinch-hitter but he hit .263/.358/.474 with an OPS+ of 103 and a WAR of 0.6. Now, he’s one of the Padres TV color analysts.