Thanks for all the information in this thread and the Octopus Go thread. Didn't know anything about all this until I signed up to this forum a few months ago. I am now a recent convert to Octopus Go, and like everyone else on Go, looking at whether Agile will benefit.
Here is an agile tariff link for Eastern England for various time periods, including predictions for next 24 hours.
https://www.energy-stats.uk/octopus-agile-eastern-england/
Click the Agile Tariff tab near the top for your area.
The interesting graph is the Go vs Agile comparison average for each half hour slot of the day covering the past 365 days. For Eastern England, Agile is typically 5-6p per unit during the period where Go is a fixed 5p per unit (00:30-04:30).
For now, my preference is to stick to the simple approach that is Octopus Go - I know that every night I would pay 5p per unit for four hours, seven days a week. But I know that some would prefer the chase that is Octopus Agile.