Interval Data (Beta)

The Interval Data product endpoint at Deck allows you to access real-time, granular energy consumption data from utilities across multiple sites. By retrieving data at intervals as short as 5, 15, or 60 minutes, you can:

• Monitor energy use in real time to optimize consumption and reduce costs.

• Identify patterns and inefficiencies that can be corrected to improve operational efficiency.

• Track energy usage for sustainability goals or demand-response programs with precise, time-stamped data.

Interval data is essentially a breakdown of energy usage over specific time intervals, often paired with the corresponding rate. However, utilizing this data can be complex due to the significant variability in how it’s collected, reported, and structured.

Here are the big elements of variability:

Variation	Example	Description
Interval Data Availability	Yes, No	Despite advanced Metering Infrastructure (AMI) rollout, there are significant gaps in coverage, as not all electricity providers capture and make available interval data.
Interval Length	5, 15, 30, 60 minutes	Different sites may have different interval lengths, making it hard to standardize and aggregate data across locations. Smaller intervals provide more granular insights, but comparing them with larger intervals can reduce analysis effectiveness.
Rate Data Availability	Yes, No, Commercial only	Not all utilities provide rate data tied to intervals, complicating the calculation of energy costs. This can prevent businesses from optimizing based on time-of-use rates or other cost-saving opportunities.
Data Latency	Real-time, 2 days, 5 days, 20 days	Data latency varies by utility, meaning businesses might receive data days or even weeks after usage. This prevents real-time decision-making and can impact demand response programs or accurate billing.

Sample Response for the Interval Endpoint:

{
  "source_name": "Consolidated Edison",
  "source_country": "US",
  "username": "[email protected]",
  "accounts": [
    {
      "account_number": "123456789",
      "interval_data": [
        {
          "meter_id": "MTR-123456",
          "service_address": "789 Park Ave, Suite 100\nNew York, NY 10021",
          "service_type": "Electric",
          "service_plan": "EL15 Commercial Standard",
          
          // Interval details
          "interval_start_date": "2025-01-01T00:00:00Z",
          "interval_end_date": "2025-03-31T23:45:00Z",
          "interval_duration_minutes": 15,
          "total_intervals": 8640,

          // Interval usage and rate details (start of the list)
          "intervals": [
            {
              "timestamp": "2025-01-01T00:00:00Z",
              "usage_kwh": 22.5,
              "rate": 0.15,
              "cost": 3.38
            },
            {
              "timestamp": "2025-01-01T00:15:00Z",
              "usage_kwh": 20.8,
              "rate": 0.15,
              "cost": 3.12
            },
            {
              "timestamp": "2025-01-01T00:30:00Z",
              "usage_kwh": 19.2,
              "rate": 0.15,
              "cost": 2.88
            },
            {
              "timestamp": "2025-01-01T00:45:00Z",
              "usage_kwh": 21.3,
              "rate": 0.15,
              "cost": 3.20
            },

            // A long list of intervals continues...

            {
              "timestamp": "2025-02-15T12:00:00Z",
              "usage_kwh": 24.2,
              "rate": 0.16,
              "cost": 3.87
            },
            {
              "timestamp": "2025-02-15T12:15:00Z",
              "usage_kwh": 23.6,
              "rate": 0.16,
              "cost": 3.78
            },

            // Break for readability
            "... (many more intervals in between) ...",

            // Interval usage and rate details (end of the list)
            {
              "timestamp": "2025-03-31T22:30:00Z",
              "usage_kwh": 21.7,
              "rate": 0.15,
              "cost": 3.25
            },
            {
              "timestamp": "2025-03-31T22:45:00Z",
              "usage_kwh": 22.1,
              "rate": 0.15,
              "cost": 3.32
            },
            {
              "timestamp": "2025-03-31T23:00:00Z",
              "usage_kwh": 20.6,
              "rate": 0.15,
              "cost": 3.09
            },
            {
              "timestamp": "2025-03-31T23:15:00Z",
              "usage_kwh": 19.8,
              "rate": 0.15,
              "cost": 2.97
            },
            {
              "timestamp": "2025-03-31T23:30:00Z",
              "usage_kwh": 21.9,
              "rate": 0.15,
              "cost": 3.28
            },
            {
              "timestamp": "2025-03-31T23:45:00Z",
              "usage_kwh": 20.4,
              "rate": 0.15,
              "cost": 3.06
            }
          ],

          // Total usage and costs for the 3-month period
          "total_usage_kwh": 187200.0,
          "total_cost": 28080.00,
          "currency_code": "USD"
        }
      ]
    }
  ]
}

Interval Endpoint Data Dictionary

Field Name	Type	Description
source_name	String	The name of the utility provider supplying the data (e.g., “Consolidated Edison”).
source_country	String	The two-letter country code (ISO 3166-1 alpha-2) representing the country associated with the account or service (e.g., “US” for the United States)
username	String	A unique identifier for the user that is used to authenticate and associate API requests with the correct account. This is typically an email address, username, or another form of user ID registered with the platform or service.
accounts	Array	A list of accounts associated with the user. Contains account and statement data.
account_number	String	The unique identifier for the user’s account with the utility.
interval_data	Array	A list of interval data records associated with the account.
meter_id	String	The unique identifier for the meter that recorded the interval data.
service_address	String	The address where the service is provided (e.g., the building location).
service_type	String	The type of utility service (e.g., “Electric”).
service_plan	String	The specific service plan associated with the meter (e.g., “EL15 Commercial Standard”).
interval_start_date	String (Date)	The start date for the interval data period (e.g., “2025-01-01”).
interval_end_date	String (Date)	The end date for the interval data period (e.g., “2025-03-31”).
interval_duration_minutes	Integer	The length of time in minutes for each interval (e.g., 15 minutes).
total_intervals	Integer	The total number of intervals within the given period (e.g., 8640 for 3 months).
intervals	Array	A list of interval usage records, each containing timestamp, usage, rate, and cost.
timestamp	String (DateTime)	The date and time of the specific interval (e.g., “2025-01-01T00:00:00Z”).
usage_kwh	Float	The amount of energy used during the interval in kilowatt-hours (kWh).
rate	Float	The rate applied during that interval in the user’s currency (e.g., USD/kWh).
cost	Float	The cost associated with that specific interval (e.g., energy usage multiplied by rate).
total_usage_kwh	Float	The total amount of energy consumed during the interval period (e.g., 187200 kWh for 3 months).
total_cost	Float	The total cost for the entire interval period (e.g., 28080 for 3 months).
currency_code	String	The currency used for the costs (e.g., “USD”).