Ask the Grid

Overview

ISO-NE's published PER Hourly source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
locationLowCardinality(String)
rtlmplocationLowCardinality(String)
rtlmpNullable(Float64)
perfuel_typeLowCardinality(String)
strike_priceNullable(Float64)
system_loadNullable(Float64)
scale_factorNullable(Float64)
hourly_perNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timelocationrtlmplocationrtlmpperfuel_typestrike_pricesystem_loadscale_factorhourly_peringested_at
2019-06-01 03:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP31.9OIL344.9611805.6010.4452902026-07-30 20:18:10.577684
2019-06-01 02:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP32.79OIL344.9613253.5720.4999102026-07-30 20:18:10.577684
2019-06-01 01:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP30.52OIL344.9614423.620.5440402026-07-30 20:18:10.577684
2019-06-01 00:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP30.88OIL344.9614517.2210.5475702026-07-30 20:18:10.577684
2019-05-31 23:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP29.67OIL344.9614550.6530.5488302026-07-30 20:18:10.577684
2019-05-31 22:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP31.65OIL344.9614995.0430.5655902026-07-30 20:18:10.577684
2019-05-31 21:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP37.82OIL344.9615546.6230.586402026-07-30 20:18:10.577684
2019-05-31 20:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP30.66OIL344.9615780.9480.5952402026-07-30 20:18:10.577684
2019-05-31 19:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP20.44OIL344.9615200.880.5733602026-07-30 20:18:10.577684
2019-05-31 18:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP21.53OIL344.9614894.3210.561802026-07-30 20:18:10.577684
2019-05-31 17:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP26OIL344.9615078.840.5687602026-07-30 20:18:10.577684
2019-05-31 16:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP27.91OIL344.9614948.4120.5638402026-07-30 20:18:10.577684
2019-05-31 15:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP31.79OIL344.9614413.6640.5436702026-07-30 20:18:10.577684
2019-05-31 14:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP27.22OIL344.9614265.4510.5380802026-07-30 20:18:10.577684
2019-05-31 13:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP26.69OIL344.9614188.5520.5351702026-07-30 20:18:10.577684
2019-05-31 12:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP19.12OIL344.9613803.1240.5206402026-07-30 20:18:10.577684
2019-05-31 11:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP23.68OIL344.9613116.1940.4947302026-07-30 20:18:10.577684
2019-05-31 10:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP17.75OIL344.9612017.4050.4532802026-07-30 20:18:10.577684
2019-05-31 09:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP15.41OIL344.9610868.9730.4099602026-07-30 20:18:10.577684
2019-05-31 08:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP2.94OIL344.9610304.4180.3886702026-07-30 20:18:10.577684
2019-05-31 07:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP2.42OIL344.9610214.2710.3852702026-07-30 20:18:10.577684
2019-05-31 06:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP-2.65OIL344.969987.8360.3767302026-07-30 20:18:10.577684
2019-05-31 05:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP-0.12OIL344.9610326.4220.389502026-07-30 20:18:10.577684
2019-05-31 04:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP7.69OIL344.9610655.8510.4019302026-07-30 20:18:10.577684
2019-05-31 03:00:00.000000{"value": "Southeast New England", "CapacityZoneId": 8506}Real-Time LMP0.73OIL354.211449.2840.4318502026-07-30 20:18:10.577684

Coverage

100.0% complete0 gap days32 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 32Gaps: 0
2019
gaplessmore