[Bug]: `AgentTransactions` generated by Seeder don't populate `agent_balance_histories`

### Preflight Checklist

- [x] I have read the [Contributing Guidelines](https://github.com/EnAccess/micropowermanager/blob/main/CONTRIBUTING.md) for this project, if it exists.
- [x] I agree to follow the [Code of Conduct](https://github.com/EnAccess/micropowermanager/blob/main/CODE_OF_CONDUCT.md) that this project adheres to.
- [x] I have searched the [issue tracker](https://github.com/EnAccess/micropowermanager/issues) for a feature request that matches the one I want to file, without success.

### Expected Behavior

Currently, the Transaction data generator does create Agent Transactions as well.

However, these to not correctly populate and adapt the Agents balance and their history. And example of how this could look like can be found in `dummy_agent_data.sql`.

After this has be resolved, the `dummy_agent_data.sql` can be removed.

### Actual Behavior

see above

### Steps to reproduce

see above

### What operating system(s) are you using?

macOS

### Additional Information

_No response_