https://www.forbes.com/sites/jonbruner/2011/10/20/the-high-s... has some interesting data on the Columbia River and its dams.

From that https://youtu.be/jvnaiHFT6nQ is a visualization of the water releases for the river to allow the water to get to the right dam for the anticipated power use.