View Source

Date	Author	Version	Change Description
08.08.2023	Nikola Trajković	0.1 Draft	No previous document
10.08.2023	Nikola Trajković	0.2 Draft	Added new details about source system, files and transformations

Source Descriptions:

METEOLOGICA (FTP server):

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

Folders:

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):

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:

GSHEETS:

Example of the structure: