| #! /bin/sh | |
| # @author: Claus Witt | |
| # http://clauswitt.com/319.html | |
| # Adding or Removing Items to hosts file | |
| # Use -h flag for help | |
| DEFAULT_IP=127.0.0.1 | |
| IP=${3:-$DEFAULT_IP} |
| esphomeyaml: | |
| name: pow | |
| platform: ESP8266 | |
| board: esp01_1m | |
| board_flash_mode: dout | |
| wifi: | |
| ssid: 'Demo' | |
| password: 'Livestream' |
See http://randyzwitch.com/mapd-pjm-electricity-data/ for the data and pythons
script to create hourly_loads.csv (146MB) and
https://news.ycombinator.com/item?id=16458105 for discussion.
CREATE TABLE hourly_loads (
actual_date date,
zone_name text,