Table: GSH_TRANSACTION_SUMMARY

GSH_TRANSACTION_SUMMARY

Name

GSH_TRANSACTION_SUMMARY

Comment

The report provides a summary of all trades executed in the current gas day per product. It provides information on the high/low open/close prices, total traded quantities and number of trades.


Primary Key Columns

Name

CURRENTDATE

FROM_GAS_DATE

PRODUCT_LOCATION

PRODUCT_TYPE

TO_GAS_DATE


Content

Name

Data Type

Mandatory

Comment

CURRENTDATE

DATE

X

The current gas date

PRODUCT_LOCATION

VARCHAR2(80)

X

Product location for the Gas Supply Hub market

PRODUCT_TYPE

VARCHAR2(80)

X

The product delivery period for the Gas Supply Hub market

FROM_GAS_DATE

DATE

X

The start gas day for the order delivery period

TO_GAS_DATE

DATE

X

The end gas day for the order delivery period

HIGH_PRICE

NUMBER(18,8)

 

Highest price between all trades executed today per product in $/GJ

LOW_PRICE

NUMBER(18,8)

 

Lowest price between all trades executed today per product in $/GJ

OPEN_PRICE

NUMBER(18,8)

 

The first price of all trades executed today per product in $/GJ

CLOSE_PRICE

NUMBER(18,8)

 

The last price of all trades executed today per product in $/GJ

VOLUME_WEIGHTED_AVERAGE_PRICE

NUMBER(18,8)

 

The volume weighted average price for all trades executed today per product in $/GJ

TOTAL_QUANTITY

NUMBER(18,8)

 

Total traded quantities for all trades executed today per product in GJ/day

TOTAL_NUMBER_OF_TRADES

NUMBER(18,0)

 

Total number of all executed trades today per product

LASTCHANGED

DATE

 

The date and time the report was generated