Price spikes at one node
For power traders
A price spike only matters if it is unusual for that node at that hour: 4 pm in August is not 4 am in April. Today that takes a data team to normalise every node against its own history before anyone can trade on it.
- Energy & power
- 3 steps
- In development
How it will work
This database is in development. These are the steps it is being built to answer, in the same query language as the live databases.
Each node's own normal
Prices per node and hour are series with their own seasonal baseline, so a spike is measured against what that node usually does at that hour and time of year.
Spikes as ranked events
Every spike becomes an event scored for rarity at that node, so one query lists this week's rarest spikes across the grid.
The conditions at the time
Each spike is joined with load and with the Weather database's temperature for the nearest station, so you see whether heat, load or something else drove it.
What you will get
This week's rarest spikes across the grid, each with the node, hour, load and temperature at the time.
Need this?
Tell us, and it moves up the list. We will show you where it stands.