Historic GTMA Trades Data - Apr 2017 - March 2018

This file includes all historic GTMA (Grid Trade Master Agreement) trades between April 2017 to March 2018. This data file will be updated on a monthly basis.

CKAN Data API

Access resource data via a web API with powerful query support.
Further information in the main CKAN Data API and DataStore documentation.

The Data API can be accessed via the following actions of the CKAN action API.

Query
`https://api.nationalgrideso.com/api/3/action/datastore_search`
Query (via SQL)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql`

Query example (first 5 results)
`https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=6f2772a4-ac7a-4eb7-a8ee-59ca6a03e205&limit=5`
Query example (via SQL statement)
`https://api.nationalgrideso.com/api/3/action/datastore_search_sql?sql=SELECT * from "6f2772a4-ac7a-4eb7-a8ee-59ca6a03e205" LIMIT 5`

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: '6f2772a4-ac7a-4eb7-a8ee-59ca6a03e205', // the resource id
  limit: 5 // get 5 results
};
$.ajax({
  url: 'https://api.nationalgrideso.com/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});

A simple ajax (JSONP) request to the data API using jQuery.

import urllib2
  url = 'https://api.nationalgrideso.com/api/3/action/datastore_search?resource_id=6f2772a4-ac7a-4eb7-a8ee-59ca6a03e205&limit=5'
  fileobj = urllib2.urlopen(url)
  print fileobj.read()

Download (CSV)

Data Explorer

Table Information

Trade ID

Title	Trade ID
Type	string
Description	Trade ID.
Comment	N/A
Example	ES12345678
Unit	N/A

Start Time

Title	Start Time
Type	datetime
Description	Trade start date time (UTC)
Comment	N/A
Example	2017-04-05T22:30:00Z
Unit	N/A

End Time

Title	End Time
Type	datetime
Description	Trade end date time (UTC).
Comment	N/A
Example	2017-04-05T23:00:00Z
Unit	N/A

Volume

Title	Volume
Type	integer
Description	Total volume for the trade.
Comment	N/A
Example	2080
Unit	MWh

Price

Title	Price
Type	number
Description	Price of the trade.
Comment	N/A
Example	26.7
Unit	£/MWh

Cost

Title	Cost
Type	integer
Description	Cost of the trades.
Comment	If National Grid ESO pay, than cost is positive
Example	93840
Unit	£

SO Flag

Title	System Operator Flag
Type	string
Description	Either T: System trade or F: Energy trade.
Comment	N/A
Example	T
Unit	N/A

For any queries or feedback please contact [email protected]

You are now signed in

Historic GTMA Trades Data - Apr 2017 - March 2018

CKAN Data API

Data Explorer

Data Explorer

Table Information

Trade ID

Start Time

End Time

Volume

Price

Cost

SO Flag