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)
相关数据集
- PJM Electricity Counterparty Forward Curve 1-3 MW
- NYISO Electricity Counterpary Forward Curve 1-3 MW
- ERCOT Electricity Counterpary Forward Curve <1 MW
- ERCOT Electricity Counterpary Forward Curve 1-3 MW
- NYISO Electricity Counterpary Forward Curve <1 MW
- 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
搜集汇总
数据集介绍

以上内容由遇见数据集搜集并总结生成



