As the share of renewables grows in the energy mix, the unpredictability of electrical supply and demand creates the need to compute Price Forward Curves (PFC) more frequently.
The PFC is used to hedge trades and is often a source of alpha for trading firms.
A Price Forward Curve is heavily influenced by supply and demand, especially for commodities like electricity. That’s because transporting and storing energy is extremely expensive.
Seasonality is a typical factor of price variation. With the introduction of renewables in the energy grid, the price variation has a much greater unpredictability.
This change requires trading firms to incorporate weather data and recompute the PFC regularly, possibly every minute. That puts massive stress on the system that was not designed for that data pressure.
Energy trading firms typically built a system architecture relying on a relational database that was sufficient to handle previous volumes. The increased workload on the database results in unrealistic budgets or infrastructure size.
Quasar is connected directly to the market data provider and captures the data without a third-party tool. Capture is done with virtually no latency.
Quasar uses its unique suite of compression algorithms to compress the data faster than it arrives and use its micro-indexes to reduce future lookup and feature extraction time. This results in significantly reduced disk usage without impacting the queryability of the data.
Each instrument is stored as a timeseries a two dedicated tables (one for orders, one for trades). Weather data is organized by source.
Tables can be tagged at will, enabling a flexing querying mechanism based on those tags. Tags can be queried recursively. For example, obtaining all the instruments of an index or all the weather data of a specific region.
Queries use a SQL interface, dedicated API, or one of the numerous connectors available. For example, traders can load data directly into Tableau using the Quasar ODBC driver. Quants can load timeseries directly into Python Pandas using the Quasar Pandas API.
Quasar has built-in capabilities to accelerate the computation of Price Forward Curve. It can transform the data in real-time to significantly simplify the effort needed to get a result.