Table: GSH_HISTORICAL_SUMMARY

GSH_HISTORICAL_SUMMARY

Name

GSH_HISTORICAL_SUMMARY

Comment

The report provides a summary of all trades delivered in the current gas day and the last thirty gas days per product location. It provides information on the volume weighted average price, and the total traded quantities.


Primary Key Columns

Name

GAS_DATE

PRODUCT_LOCATION


Content

Name

Data Type

Mandatory

Comment

GAS_DATE

DATE

X

The gas date when the delivery of trades occurred

PRODUCT_LOCATION

VARCHAR2(80)

X

Product location for the Gas Supply Hub market

VOLUME_WEIGHTED_AVERAGE_PRICE

NUMBER(18,8)

 

The volume weighted average price for trades delivered in the specified gas day at the specified location in $/GJ

TOTAL_QUANTITY

NUMBER(18,8)

 

Total traded quantities for the specified gas day at the specified location in GJ/day

ROLLING_WEIGHTED_AVERAGE_PRICE

NUMBER(18,8)

 

The rolling 30 days volume weighted average price for trades delivered in the last 30 days at the specified location in $/GJ

LASTCHANGED

DATE

 

The date and time the report was generated