4. Data Sources

Change Record

Reviewers

Source Descriptions:

• FTP Server:

METEOLOGICA (FTP server):

CSV files containing data about the forecast prices by country - Spain, Italy, Germany, France. 

Folders:

• /20160301/Europe/Spain/PowerPrice/Forecast/Meteologica/Total/Hourly
• /20160301/Europe/Spain/PowerPrice/Forecast/ECMWF-ENS/Total/Hourly
• /20160301/Europe/Spain/PowerPrice/Observation/Total/Hourly
• /20160301/Europe/Italy/PowerPrice/Forecast/Meteologica/CNOR/Total/Hourly
• /20160301/Europe/France/PowerPrice/Forecast/Meteologica/Total/Hourly
• /20160301/Europe/Germany/PowerPrice/Forecast/Meteologica/Total/Hourly

Folder structure (Example, /20160301/Europe/France/PowerPrice/Forecast/Meteologica/Total/Hourly for 2023.08.26):

• France_PowerPrice_Forecast_Meteologica_post-ECMWF-ENS_Total_Hourly_202308260000.csv (data from 10 am)
• csv (data from 2 pm)
• csv (data from 4 pm)
• France_PowerPrice_Forecast_Meteologica_post-ECMWF-ENS_Total_Hourly_202308261200.csv (data from 10 pm)

Files with the same date contain the same data, provided 4 times a day.

Structure of the files (example France_PowerPrice_Forecast_Meteologica_post-ECMWF-ENS_Total_Hourly_202308260000.csv): 

• Database:

VENDOHM DATABASE: 

Gas & electricity (weekly, monthly, yearly values by location)

• Tables with prices with the same structure (mapping is provided in the Excel file "List of tables_filters for Vendohm database of Robustify")
• Meteo table curve_n_ometeo_870  (mapping with the definitions and curve IDs provided in the Excel file "Vendohm_meteo_mapping" -this should be provided as a Metadata table)
• Table curve_n_pegas_325 - gas and electricity prices (mapping to be defined)

Example of the structure: 

• Google Sheets:

GSHEETS:

• Hedges - All sites
• WAP Solid Fuels
• CO2(structure to be defined)

Example of the structure: