EquationDB

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.

  1. 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.

  2. 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.

  3. 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.

Tell us you need this

More energy & power use cases