{ "cells": [ { "cell_type": "markdown", "id": "03c87582", "metadata": {}, "source": [ "# Python API Example - Access Terminal Costs Import and Storage in Dataframe\n", "\n", "This guide is designed to provide an example of how to access the Spark API:\n", "- The path to your client credentials is the only input needed to run this script (just before Section 2)\n", "- This script has been designed to display the raw outputs of requests from the API, and then shows you how to format those outputs to enable easy reading and analysis\n", "- This script can be copied and pasted by customers for quick use of the API\n", "\n", "__N.B. This guide is just for Access terminal data. If you're looking for other API data products (such as contract prices, Freight routes or Netbacks), please refer to their according code example files.__ " ] }, { "cell_type": "markdown", "id": "21bd6181", "metadata": {}, "source": [ "### Have any questions?\n", "\n", "If you have any questions regarding our API, or need help accessing specific datasets, please contact us at:\n", "\n", "__data@sparkcommodities.com__\n", "\n", "or refer to our API website for more information about this endpoint: https://www.sparkcommodities.com/api/request/access.html" ] }, { "cell_type": "markdown", "id": "0037c795", "metadata": {}, "source": [ "## 1. Importing Data\n", "\n", "Here we define the functions that allow us to retrieve the valid credentials to access the Spark API.\n", "\n", "This section can remain unchanged for most Spark API users." ] }, { "cell_type": "code", "execution_count": 1, "id": "5cbcba1b", "metadata": {}, "outputs": [], "source": [ "# import libraries for callin the API\n", "import json\n", "import os\n", "import sys\n", "import pandas as pd\n", "from base64 import b64encode\n", "from urllib.parse import urljoin\n", "from pprint import pprint\n", "\n", "try:\n", " from urllib import request, parse\n", " from urllib.error import HTTPError\n", "except ImportError:\n", " raise RuntimeError(\"Python 3 required\")" ] }, { "cell_type": "code", "execution_count": 2, "id": "b7442d2b", "metadata": {}, "outputs": [], "source": [ "# defining query functions \n", "API_BASE_URL = \"https://api.sparkcommodities.com\"\n", "\n", "\n", "def retrieve_credentials(file_path=None):\n", " \"\"\"\n", " Find credentials either by reading the client_credentials file or reading\n", " environment variables\n", " \"\"\"\n", " if file_path is None:\n", " client_id = os.getenv(\"SPARK_CLIENT_ID\")\n", " client_secret = os.getenv(\"SPARK_CLIENT_SECRET\")\n", " if not client_id or not client_secret:\n", " raise RuntimeError(\n", " \"SPARK_CLIENT_ID and SPARK_CLIENT_SECRET environment vars required\"\n", " )\n", " else:\n", " # Parse the file\n", " if not os.path.isfile(file_path):\n", " raise RuntimeError(\"The file {} doesn't exist\".format(file_path))\n", "\n", " with open(file_path) as fp:\n", " lines = [l.replace(\"\\n\", \"\") for l in fp.readlines()]\n", "\n", " if lines[0] in (\"clientId,clientSecret\", \"client_id,client_secret\"):\n", " client_id, client_secret = lines[1].split(\",\")\n", " else:\n", " print(\"First line read: '{}'\".format(lines[0]))\n", " raise RuntimeError(\n", " \"The specified file {} doesn't look like to be a Spark API client \"\n", " \"credentials file\".format(file_path)\n", " )\n", "\n", " print(\">>>> Found credentials!\")\n", " print(\n", " \">>>> Client_id={}****, client_secret={}****\".format(\n", " client_id[:5], client_secret[:5]\n", " )\n", " )\n", "\n", " return client_id, client_secret\n", "\n", "\n", "def do_api_post_query(uri, body, headers):\n", " \"\"\"\n", " OAuth2 authentication requires a POST request with client credentials before accessing the API. \n", " This POST request will return an Access Token which will be used for the API GET request.\n", " \"\"\"\n", " url = urljoin(API_BASE_URL, uri)\n", "\n", " data = json.dumps(body).encode(\"utf-8\")\n", "\n", " # HTTP POST request\n", " req = request.Request(url, data=data, headers=headers)\n", " try:\n", " response = request.urlopen(req)\n", " except HTTPError as e:\n", " print(\"HTTP Error: \", e.code)\n", " print(e.read())\n", " sys.exit(1)\n", "\n", " resp_content = response.read()\n", "\n", " # The server must return HTTP 201. Raise an error if this is not the case\n", " assert response.status == 201, resp_content\n", "\n", " # The server returned a JSON response\n", " content = json.loads(resp_content)\n", "\n", " return content\n", "\n", "\n", "def do_api_get_query(uri, access_token):\n", " \"\"\"\n", " After receiving an Access Token, we can request information from the API.\n", " \"\"\"\n", " url = urljoin(API_BASE_URL, uri)\n", "\n", " headers = {\n", " \"Authorization\": \"Bearer {}\".format(access_token),\n", " \"accept\": \"application/json\",\n", " }\n", "\n", " print(f\"Fetching {url}\")\n", "\n", " # HTTP GET request\n", " req = request.Request(url, headers=headers)\n", " try:\n", " response = request.urlopen(req)\n", " except HTTPError as e:\n", " print(\"HTTP Error: \", e.code)\n", " print(e.read())\n", " sys.exit(1)\n", "\n", " resp_content = response.read()\n", "\n", " # The server must return HTTP 201. Raise an error if this is not the case\n", " assert response.status == 200, resp_content\n", "\n", " # The server returned a JSON response\n", " content = json.loads(resp_content)\n", "\n", " return content\n", "\n", "\n", "def get_access_token(client_id, client_secret):\n", " \"\"\"\n", " Get a new access_token. Access tokens are the thing that applications use to make\n", " API requests. Access tokens must be kept confidential in storage.\n", "\n", " # Procedure:\n", "\n", " Do a POST query with `grantType` and `scopes` in the body. A basic authorization\n", " HTTP header is required. The \"Basic\" HTTP authentication scheme is defined in\n", " RFC 7617, which transmits credentials as `clientId:clientSecret` pairs, encoded\n", " using base64.\n", " \"\"\"\n", "\n", " # Note: for the sake of this example, we choose to use the Python urllib from the\n", " # standard lib. One should consider using https://requests.readthedocs.io/\n", "\n", " payload = \"{}:{}\".format(client_id, client_secret).encode()\n", " headers = {\n", " \"Authorization\": b64encode(payload).decode(),\n", " \"Accept\": \"application/json\",\n", " \"Content-Type\": \"application/json\",\n", " }\n", " body = {\n", " \"grantType\": \"clientCredentials\",\n", " \"scopes\": \"read:access\",\n", " }\n", "\n", " content = do_api_post_query(uri=\"/oauth/token/\", body=body, headers=headers)\n", "\n", " print(\n", " \">>>> Successfully fetched an access token {}****, valid {} seconds.\".format(\n", " content[\"accessToken\"][:5], content[\"expiresIn\"]\n", " )\n", " )\n", "\n", " return content[\"accessToken\"]" ] }, { "cell_type": "markdown", "id": "9b4b250b", "metadata": {}, "source": [ "## N.B. Credentials\n", "\n", "Here we call the above functions, and input the file path to our credentials.\n", "\n", "N.B. You must have downloaded your client credentials CSV file before proceeding. Please refer to the API documentation if you have not dowloaded them already.\n", "\n", "The code then prints the available prices that are callable from the API, and their corresponding Python ticker names are displayed as a list at the bottom of the Output." ] }, { "cell_type": "code", "execution_count": 3, "id": "3ec2647c", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ ">>>> Found credentials!\n", ">>>> Client_id=875f4****, client_secret=6cdf8****\n", ">>>> Successfully fetched an access token eyJhb****, valid 604799 seconds.\n" ] } ], "source": [ "# Insert file path to your client credentials here\n", "client_id, client_secret = retrieve_credentials(file_path=\"/tmp/client_credentials.csv\")\n", "\n", "# Authenticate:\n", "access_token = get_access_token(client_id, client_secret)" ] }, { "cell_type": "markdown", "id": "71c33c3b", "metadata": {}, "source": [ "## 2. Latest Price Release\n", "\n", "Here we call the latest price release and print it in a readable format. This is done using the URL:\n", "\n", "__/beta/sparkr/releases/latest/__\n", "\n", "\n", "We then save the entire dataset as a local variable called 'latest'." ] }, { "cell_type": "code", "execution_count": 4, "id": "5c053478", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Fetching https://api.sparkcommodities.com/beta/sparkr/releases/latest/\n" ] } ], "source": [ "## Defining the latest release function\n", "\n", "\n", "def fetch_latest_price_releases(access_token):\n", " content = do_api_get_query(\n", " uri=\"/beta/sparkr/releases/latest/\", access_token=access_token\n", " )\n", "\n", " return content[\"data\"]\n", "\n", "\n", "## Calling that function and storing the output\n", "\n", "latest = fetch_latest_price_releases(access_token)" ] }, { "cell_type": "code", "execution_count": 5, "id": "d5f82bce", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'releaseDate': '2024-10-17',\n", " 'terminalCode': 'grain-lng',\n", " 'terminalName': 'Isle of Grain',\n", " 'perVesselSize': {'160000': {'deliveryMonths': [{'month': '2024-11-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.285',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.209',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.194',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.050',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.659',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.611',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2024-12-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.274',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.194',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.198',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.016',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.613',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.623',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-01-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.299',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.216',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.201',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.092',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.679',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.633',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-02-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.306',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.222',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.202',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.117',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.7',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.637',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-03-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.293',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.212',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.199',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.073',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.667',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.626',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-04-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.250',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.178',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.19',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '3.939',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.561',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.598',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-05-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.276',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.209',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.185',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.022',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.659',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.583',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-06-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.340',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.276',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.182',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.224',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.871',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.573',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-07-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.470',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.408',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.18',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.631',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '1.285',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.566',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-08-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.470',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.408',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.18',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.633',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '1.285',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.568',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-09-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.302',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.235',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.185',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.104',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.741',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.583',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-10-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.313',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.227',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.186',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.466',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.079',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.141',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.716',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.586',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.469',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.25',\n", " 'description': 'Commodity Charge'}}}}],\n", " 'assumptions': {'vesselSizeCbm': 160000, 'dischargeVolumeMmbtu': 3492366}},\n", " '174000': {'deliveryMonths': [{'month': '2024-11-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.267',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.191',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.194',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '3.994',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.603',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.611',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2024-12-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.258',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.178',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.198',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '3.964',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.561',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.623',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-01-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.280',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.197',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.201',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.035',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.622',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.633',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-02-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.287',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.203',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.202',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.057',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.64',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.637',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-03-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.275',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.194',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.199',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.017',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.611',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.626',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-04-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.235',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.163',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.19',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '3.892',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.514',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.598',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-05-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.259',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.192',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.185',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '3.967',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.604',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.583',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-06-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.317',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.253',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.182',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.150',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.797',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.573',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-07-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.435',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.373',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.18',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.522',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '1.176',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.566',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-08-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.435',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.373',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.18',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.524',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '1.176',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.568',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-09-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.282',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.215',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.185',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.498',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.029',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.041',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.678',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.583',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.57',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.09',\n", " 'description': 'Commodity Charge'}}}},\n", " {'month': '2025-10-01',\n", " 'costsInUsdPerMmbtu': {'total': '1.294',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '0.355',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.208',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.186',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '0.466',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.079',\n", " 'description': 'Commodity Charge'}}},\n", " 'costsInEurPerMwh': {'total': '4.081',\n", " 'breakdown': {'basic-slot-berth': {'type': 'basic-slot-berth',\n", " 'value': '0.0',\n", " 'description': 'Slot (Berth)'},\n", " 'basic-slot-unload-storage-regas': {'type': 'basic-slot-unload-storage-regas',\n", " 'value': '0.0',\n", " 'description': 'Slot (Unload, Storage, Regas)'},\n", " 'basic-slot-berth-unload-storage-regas': {'type': 'basic-slot-berth-unload-storage-regas',\n", " 'value': '1.12',\n", " 'description': 'Slot (Berth, Unload, Storage, Regas)'},\n", " 'additional-storage': {'type': 'additional-storage',\n", " 'value': '0.0',\n", " 'description': 'Additional Storage'},\n", " 'additional-send-out': {'type': 'additional-send-out',\n", " 'value': '0.656',\n", " 'description': 'Additional Send Out'},\n", " 'fuel-gas-losses-gas-in-kind': {'type': 'fuel-gas-losses-gas-in-kind',\n", " 'value': '0.586',\n", " 'description': 'Fuel Gas Losses (Gas in Kind)'},\n", " 'entry-capacity': {'type': 'entry-capacity',\n", " 'value': '1.469',\n", " 'description': 'Entry Capacity'},\n", " 'commodity-charge': {'type': 'commodity-charge',\n", " 'value': '0.25',\n", " 'description': 'Commodity Charge'}}}}],\n", " 'assumptions': {'vesselSizeCbm': 174000, 'dischargeVolumeMmbtu': 3814333}}}}" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Checking structure of data\n", "latest[0]" ] }, { "cell_type": "code", "execution_count": 6, "id": "a9ecab55", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['160000', '174000']\n" ] } ], "source": [ "# Showing available vessel sizes\n", "print(list(latest[0][\"perVesselSize\"]))" ] }, { "cell_type": "markdown", "id": "a9059466", "metadata": {}, "source": [ "## Storing Data as a Dataframe\n", "\n", "Define a function to store regas costs as a Dataframe, making the data more easily readable and so that specific datasets can be indexed easily.\n", "\n", "__N.B.__ Gas in Kind, Entry Capacity and Commodity Charge cost components are only available for Premium subscribers. For Trial API users, these components are wrapped up into one variable, named 'other costs'. \n", "\n", "__Want to upgrade?__ Contact data@sparkcommodities.com to find out more!" ] }, { "cell_type": "code", "execution_count": 7, "id": "b23f8a6e", "metadata": {}, "outputs": [], "source": [ "def organise_dataframe(latest):\n", " \"\"\"\n", " This function sorts the API content into a dataframe. The columns available are Release Date, Terminal, Month, Vessel Size, $/MMBtu and €/MWh. \n", " Essentially, this function parses the Access database using the Month, Terminal and Vessel size columns as reference.\n", " \"\"\"\n", " # create columns\n", " data_dict = {\n", " 'Release Date':[],\n", " 'Terminal':[],\n", " 'Month':[],\n", " 'Vessel Size':[],\n", " 'Total $/MMBtu':[],\n", " 'Basic Slot (Berth)':[],\n", " 'Basic Slot (Unload/Stor/Regas)':[],\n", " 'Basic Slot (B/U/S/R)':[],\n", " 'Additional Storage':[],\n", " 'Additional Sendout':[],\n", " 'Gas in Kind': [],\n", " 'Entry Capacity':[],\n", " 'Commodity Charge':[]\n", " }\n", "\n", " # loop for each Terminal\n", " for l in latest:\n", " sizes_available = list(latest[0]['perVesselSize'].keys())\n", "\n", " # loop for each available size\n", " for s in sizes_available:\n", " \n", " # loop for each month (in the form: YYYY-MM-DD)\n", " for month in range(len(l['perVesselSize'][f'{s}']['deliveryMonths'])):\n", " \n", " # assigning values to each column\n", " data_dict['Release Date'].append(l[\"releaseDate\"])\n", " data_dict['Terminal'].append(l[\"terminalName\"])\n", " data_dict['Month'].append(l['perVesselSize'][f'{s}']['deliveryMonths'][month]['month'])\n", " data_dict['Vessel Size'].append(s)\n", " data_dict['Total $/MMBtu'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"total\"]))\n", " \n", " data_dict['Basic Slot (Berth)'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['basic-slot-berth']['value']))\n", " data_dict['Basic Slot (Unload/Stor/Regas)'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['basic-slot-unload-storage-regas']['value']))\n", " data_dict['Basic Slot (B/U/S/R)'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['basic-slot-berth-unload-storage-regas']['value']))\n", " data_dict['Additional Storage'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['additional-storage']['value']))\n", " data_dict['Additional Sendout'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['additional-send-out']['value']))\n", " data_dict['Gas in Kind'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['fuel-gas-losses-gas-in-kind']['value']))\n", " data_dict['Entry Capacity'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['entry-capacity']['value']))\n", " data_dict['Commodity Charge'].append(float(l['perVesselSize'][f'{s}']['deliveryMonths'][month][\"costsInUsdPerMmbtu\"][\"breakdown\"]['commodity-charge']['value']))\n", " \n", " \n", " # convert into dataframe\n", " df = pd.DataFrame(data_dict)\n", " \n", " df['Month'] = pd.to_datetime(df['Month'])\n", " df['Release Date'] = pd.to_datetime(df['Release Date'])\n", " \n", " return df\n" ] }, { "cell_type": "code", "execution_count": 8, "id": "0ae92173", "metadata": {}, "outputs": [], "source": [ "prices_df = organise_dataframe(latest)" ] }, { "cell_type": "code", "execution_count": 9, "id": "afebbd0c", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Release Date | \n", "Terminal | \n", "Month | \n", "Vessel Size | \n", "Total $/MMBtu | \n", "Basic Slot (Berth) | \n", "Basic Slot (Unload/Stor/Regas) | \n", "Basic Slot (B/U/S/R) | \n", "Additional Storage | \n", "Additional Sendout | \n", "Gas in Kind | \n", "Entry Capacity | \n", "Commodity Charge | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2024-11-01 | \n", "174000 | \n", "0.420 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.166 | \n", "0.057 | \n", "0.01 | \n", "
61 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2024-12-01 | \n", "174000 | \n", "0.430 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.168 | \n", "0.065 | \n", "0.01 | \n", "
62 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-01-01 | \n", "174000 | \n", "0.440 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.169 | \n", "0.074 | \n", "0.01 | \n", "
63 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-02-01 | \n", "174000 | \n", "0.433 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.170 | \n", "0.066 | \n", "0.01 | \n", "
64 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-03-01 | \n", "174000 | \n", "0.421 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.169 | \n", "0.055 | \n", "0.01 | \n", "
65 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-04-01 | \n", "174000 | \n", "0.400 | \n", "0.0 | \n", "0.0 | \n", "0.177 | \n", "0.001 | \n", "0.009 | \n", "0.163 | \n", "0.040 | \n", "0.01 | \n", "
66 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-05-01 | \n", "174000 | \n", "0.387 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.162 | \n", "0.027 | \n", "0.01 | \n", "
67 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-06-01 | \n", "174000 | \n", "0.380 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.161 | \n", "0.021 | \n", "0.01 | \n", "
68 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-07-01 | \n", "174000 | \n", "0.380 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.161 | \n", "0.021 | \n", "0.01 | \n", "
69 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-08-01 | \n", "174000 | \n", "0.380 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.161 | \n", "0.021 | \n", "0.01 | \n", "
70 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-09-01 | \n", "174000 | \n", "0.387 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.162 | \n", "0.027 | \n", "0.01 | \n", "
71 | \n", "2024-10-17 | \n", "Zeebrugge | \n", "2025-10-01 | \n", "174000 | \n", "0.404 | \n", "0.0 | \n", "0.0 | \n", "0.178 | \n", "0.001 | \n", "0.009 | \n", "0.162 | \n", "0.044 | \n", "0.01 | \n", "
\n", " | Release Date | \n", "Terminal | \n", "Month | \n", "Vessel Size | \n", "Total $/MMBtu | \n", "Basic Slot (Berth) | \n", "Basic Slot (Unload/Stor/Regas) | \n", "Basic Slot (B/U/S/R) | \n", "Additional Storage | \n", "Additional Sendout | \n", "Gas in Kind | \n", "Entry Capacity | \n", "Commodity Charge | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2024-10-17 | \n", "Montoir | \n", "2024-11-01 | \n", "160000 | \n", "0.367 | \n", "0.028 | \n", "0.176 | \n", "0.00 | \n", "0.0 | \n", "0.0 | \n", "0.062 | \n", "0.101 | \n", "0.0 | \n", "
1 | \n", "2024-10-17 | \n", "Montoir | \n", "2024-12-01 | \n", "160000 | \n", "0.368 | \n", "0.028 | \n", "0.176 | \n", "0.00 | \n", "0.0 | \n", "0.0 | \n", "0.063 | \n", "0.101 | \n", "0.0 | \n", "
2 | \n", "2024-10-17 | \n", "Montoir | \n", "2025-01-01 | \n", "160000 | \n", "0.369 | \n", "0.028 | \n", "0.176 | \n", "0.00 | \n", "0.0 | \n", "0.0 | \n", "0.064 | \n", "0.101 | \n", "0.0 | \n", "
3 | \n", "2024-10-17 | \n", "Montoir | \n", "2025-02-01 | \n", "160000 | \n", "0.369 | \n", "0.028 | \n", "0.176 | \n", "0.00 | \n", "0.0 | \n", "0.0 | \n", "0.064 | \n", "0.101 | \n", "0.0 | \n", "
4 | \n", "2024-10-17 | \n", "Montoir | \n", "2025-03-01 | \n", "160000 | \n", "0.369 | \n", "0.028 | \n", "0.176 | \n", "0.00 | \n", "0.0 | \n", "0.0 | \n", "0.064 | \n", "0.101 | \n", "0.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1369 | \n", "2024-10-15 | \n", "Dunkerque | \n", "2025-06-01 | \n", "174000 | \n", "0.714 | \n", "0.000 | \n", "0.000 | \n", "0.61 | \n", "0.0 | \n", "0.0 | \n", "0.000 | \n", "0.104 | \n", "0.0 | \n", "
1370 | \n", "2024-10-15 | \n", "Dunkerque | \n", "2025-07-01 | \n", "174000 | \n", "0.714 | \n", "0.000 | \n", "0.000 | \n", "0.61 | \n", "0.0 | \n", "0.0 | \n", "0.000 | \n", "0.104 | \n", "0.0 | \n", "
1371 | \n", "2024-10-15 | \n", "Dunkerque | \n", "2025-08-01 | \n", "174000 | \n", "0.714 | \n", "0.000 | \n", "0.000 | \n", "0.61 | \n", "0.0 | \n", "0.0 | \n", "0.000 | \n", "0.104 | \n", "0.0 | \n", "
1372 | \n", "2024-10-15 | \n", "Dunkerque | \n", "2025-09-01 | \n", "174000 | \n", "0.714 | \n", "0.000 | \n", "0.000 | \n", "0.61 | \n", "0.0 | \n", "0.0 | \n", "0.000 | \n", "0.104 | \n", "0.0 | \n", "
1373 | \n", "2024-10-15 | \n", "Dunkerque | \n", "2025-10-01 | \n", "174000 | \n", "0.714 | \n", "0.000 | \n", "0.000 | \n", "0.61 | \n", "0.0 | \n", "0.0 | \n", "0.000 | \n", "0.104 | \n", "0.0 | \n", "
1374 rows × 13 columns
\n", "