five

PJM Electricity Counterparty Forward Curve <1 MW

收藏
Snowflake2025-06-17 更新2025-06-19 收录
下载链接:
https://app.snowflake.com/marketplace/listing/GZ2FQZ18DD45
下载链接
链接失效反馈
官方服务:
资源简介:
This dataset includes electricity forward curves for 26 deregulated zones in PJM. This dataset is best used to forecast the price of electricity future contracts that are contracted through counterparties (not through the public exchange) with volumes <1 MW. Data is updated daily and it is recommended to use the latest available data when forecasting contract prices. 3 years of historical data is available to enable easy mark-to-market accounting and lookback analysis. <br/>Source: This data is sourced from ICE ([ice.com](http://ice.com/)) and is augmented using proprietary data and industry expertise.
提供机构:
Willard Energy Software
创建时间:
2025-06-17
原始信息汇总

PJM Electricity Counterparty Forward Curve <1 MW 数据集概述

数据集简介

  • 数据内容: 包含PJM 26个放松管制区域的电力远期曲线数据
  • 最佳用途: 预测通过交易对手(非公开交易所)签订的小型(<1MW)电力期货合约价格
  • 数据更新频率: 每日更新
  • 历史数据: 3年历史数据
  • 数据来源: ICE(ice.com)数据增强,结合专有数据和行业专业知识

商业需求

定价分析

  • 零售电力固定价格合同费率计算:预测能源期货合约成本以覆盖客户消费

资产估值

  • 发电资产估值:使用期货市场预测资产发电价值

监管报告

  • 市值计价和账面估值:跟踪现有电力期货合约波动以符合监管要求

数据字典

表名: SMALL_ELECTRICITY_FORWARDS_PJM

字段名称 类型 描述
CURVE_DATE Date 曲线日期
DELIVERY_MONTH_START Date 交付月份开始日期
ISO Varchar ISO标识
MONTHS_INTO_FUTURE Number 未来月份数
PRICE_DOLLAR_MWH Number 价格(美元/兆瓦时)
TIME_BUCKET Varchar 时间段
ZONE Varchar 区域

使用示例

预测能源期货合约月度价值

sql WITH volumes AS (SELECT column1 as delivery_month_start, column2 as zone, column3 as time_bucket, column4 as volume_mwh FROM (VALUES (2026-01-01, PSEG, 7X8, 0.3), (2026-01-01, PSEG, 7X16, 0.5), (2026-02-01, PSEG, 7X8, 0.2), (2026-02-01, PSEG, 7X16, 0.4))), forwards AS (SELECT * FROM SMALL_ELECTRICITY_FORWARDS_PJM where curve_date = 2025-06-09) SELECT *, PRICE_DOLLAR_MWH * VOLUME_MWH AS COST_DOLLAR FROM forwards join volumes using (zone, time_bucket, delivery_month_start)

相关数据集

  1. PJM Electricity Counterparty Forward Curve 1-3 MW
  2. NYISO Electricity Counterpary Forward Curve 1-3 MW
  3. ERCOT Electricity Counterpary Forward Curve <1 MW
  4. ERCOT Electricity Counterpary Forward Curve 1-3 MW
  5. NYISO Electricity Counterpary Forward Curve <1 MW
  6. ISONE Electricity Counterparty Forward Curve <1 MW

技术信息

  • 刷新频率: 每日
  • 时间覆盖范围: 最近3年(按月)
  • 地理覆盖范围: 美国(13个州)
  • 云区域可用性: GCP US Central 1 (Iowa)

联系方式

  • 销售: max@willard.energy
  • 支持: max@willard.energy

类别

  • Asset Valuation
  • Energy
  • Financial
  • Pricing Analysis
  • Regulatory Reporting
搜集汇总
数据集介绍
main_image_url
以上内容由遇见数据集搜集并总结生成
5,000+
优质数据集
54 个
任务类型
进入经典数据集
二维码
社区交流群

面向社区/商业的数据集话题

二维码
科研交流群

面向高校/科研机构的开源数据集话题

数据驱动未来

携手共赢发展

商业合作