Baseball Dataset

I'm looking for an experienced data scientist to help me with my baseball dataset. Specifically, I'm in need of historical statistics back to 2008. Ideally, this information should be organized in an intuitive way which allows for further analysis. The data should include game results, as well as player profiles. I'm confident that someone with the right skill set and knowledge will be able to assist me with this task.

I would like the creation of a dataset.
The dataset should be in CSV format.

This dataset will be baseball statistics.
Here are the fields I would like to capture.

date
away_team_name
home_team_name
away_team_batting_avg
home_team_batting_avg
away_team_onbase_percentage
home_team_onbase_percentage
away_team_slugging_percentage
home_team_slugging_percentage
away_team_ERA
home_team_ERA
away_team_strikeouts_per_inning
home_team_strikeouts_per_inning
away_team_runs_allowed_per_inning
home_team_runs_allowed_per_inning
away_team_pitches_per_inning
home_team_pitches_per_inning
away_team_runs
home_team_runs

I would like all the data from 2008 until now.
Extra credit/$$$ for data from 1970 until now.

There is one more requirement for the dataset.

Each row contains the averages/percentages for that team leading up to the game in which the runs occurred. In other words, the runs are from today’s game but the stats are from the data we had before today’s game happened. Therefore we will be able to predict, given the stats we have today, what the outcome of today’s game will be.

Some of the data can be found on https://www.teamrankings.com/mlb/team-stats/
There is also some game data here on Kaggle https://www.kaggle.com/datasets/josephvm/mlb-game-data