Show HN: I Built a US Grid Telemetry API Using Azure Functions and Python

Hey HN, I'm a SysAdmin turned Dev.

Leaving your mining rigs unmonitored for the holidays is a risk, so I built a tool to automate it.

I got tired of the delayed/fragmented data from ISOs like PJM and ERCOT, so I built a normalized API to track grid stress in real-time.

The Stack:

Scrapers: Python 3.11 (Pandas/Requests) handling the messy ISO formats. Compute: Azure Functions (Consumption Plan) to keep costs near zero. Storage: Azure Data Lake Gen2 (Parquet) for historical retention.

I also wrote a simple Python client 'kill-switch' for Bitcoin miners to automate curtailment during price spikes.

Repo is here: https://github.com/Norris-Eng/gridwatch-kill-switch API is here: https://rapidapi.com/cnorris1316/api/gridwatch-us-telemetry

Happy to answer questions about the scraping logic or Azure costs!

Summary

The article describes a security vulnerability in the GridWatch system, which could allow an attacker to remotely disable critical infrastructure. The authors propose a kill switch solution to mitigate this risk and enhance the overall security of the system.

Story

Show HN: I Built a US Grid Telemetry API Using Azure Functions and Python