How to get Home EMS Spot Electricity Prices
Half-hourly / hourly consumer electricity spot curves for home battery, EV charger, and heat-pump dispatch. A run saves one row per result.
One row per result
A row has Provider, Market, Region, Price. The columns are listed in the schema on this page.
The next run
Put the run on a schedule and the next file is the latest rows.
Home EMS Spot Electricity Prices in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
provider | Provider | awattar_de |
market | Market | DE |
region | Region | CA |
price | Price | 34.44 |
currency | Currency | EUR |
unit | Unit | Eur/ |
scrapedAt | Scraped At | 2026-09-24T12:00:00.000Z |
providerProviderawattar_demarketMarketDEregionRegionCApricePrice34.44currencyCurrencyEURunitUnitEur/MWh scrapedAtScraped At2026-09-24T12:00:00.000Z