GH project with a link to the data and the instructions how to process it https://github.com/NSAPH-Projects/green-energy-optimization

"raw data" is from EIA (a veritable rabbit hole!)

>EIA publishes hourly operational data across the United States electricity grid, including demand, net generation of electricity from various sources (such as coal, natural gas, solar), CO2 emissions, import/export to other regions, and many more. The complete details of the EIA-930 data is available here: https://www.eia.gov/electricity/gridmonitor/about. Furthermore, we obtained the solar capacities of each year and each region from EIA (https://www.eia.gov/electricity/data/state/) and had stored the information in the file solar_capacity_factor.csv. (2023-07-01)