[{"_1":2,"_225":-5,"_226":-5},"loaderData",{"_3":4,"_96":97,"_209":210},"root",{"_5":6,"_37":38,"_69":70},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":22,"_36":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","isHigherTownieTier","ENV",{"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","efeea19332d9bfe7de1049656877be9cb817c45f","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","API_URL","https://api.val.town","clerkState",{"_71":72},"__internal_clerk_state",{"_73":74,"_75":48,"_76":77,"_78":77,"_79":22,"_80":77,"_81":77,"_82":77,"_83":77,"_84":85,"_94":22,"_95":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_86":22,"_21":22,"_87":77,"_88":89,"_90":77,"_91":48,"_92":22,"_93":77},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_98":99,"_100":101,"_102":46,"_103":77,"_104":105,"_106":107,"_161":162,"_183":184,"_185":186,"_197":198,"_202":-5,"_203":-5,"_204":-5,"_205":22,"_206":22,"_207":208},"handle","joshbeckman","name","comed-hourly-pricing-calendar","branchName","path","version",6,"project",{"_108":109,"_100":101,"_110":111,"_112":-5,"_113":22,"_114":115,"_116":117,"_118":-5,"_14":119,"_120":-5,"_121":22,"_122":-5,"_123":-5,"_124":125,"_16":126,"_127":-5,"_128":-5,"_129":-5,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_23":140,"_143":144,"_148":149,"_160":22},"id","d23ba47e-1508-11f1-a117-42dde27851f2","createdAt",["D",1772326305620],"deletedAt","legacyEnvVars","privacy","public","description","Subscribe to the hourly price changes of ComEd electricity","imageUrl","f8d90ec1-81be-4efc-b861-a032f3f5b85f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"b1ec36cc-9d04-4938-872f-34bf39599d6a","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_98":99,"_141":142},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJTZm1HaHJGdDFmQ2s5ME05RW9lT1JGbHZPYyIsImluaXRpYWxzIjoiSkIifQ","org",{"_98":99,"_145":142,"_14":119,"_146":147},"avatar","tier","pro","branch",{"_104":150,"_100":46,"_108":151,"_152":109,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":101,"_159":99},16,"d23c194a-1508-11f1-a117-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[163],{"_108":164,"_100":165,"_166":167,"_168":-5,"_169":151,"_170":105,"_171":22,"_110":172,"_104":173,"_174":175,"_176":177,"_178":22,"_179":-5,"_180":181,"_103":182},"0661ce08-150a-11f1-a382-42dde27851f2","main.ts","fileId","d23ef674-1508-11f1-a117-42dde27851f2","parentId","branchId","branchVersion","latest",["D",1772326822597],5,"fileType","http","content","type PricePoint = {\n millisUTC: string;\n price: string;\n};\n\ntype HourlyAverage = {\n hour: Date;\n price: number; // cents/kWh\n};\n\nexport default async function (req: Request): Promise {\n const [historicalPrices, dayAheadPrices] = await Promise.all([\n fetchHistoricalHourly(),\n fetchDayAhead(),\n ]);\n\n const allPrices = deduplicateAndMerge(historicalPrices, dayAheadPrices);\n const ical = generateICal(allPrices, 0.1); // $0.001 = 0.1 cents\n\n return new Response(ical, {\n headers: {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Content-Disposition\": 'attachment; filename=\"comed-prices.ics\"',\n },\n });\n}\n\nasync function fetchHistoricalHourly(): Promise {\n const res = await fetch(\n \"https://hourlypricing.comed.com/api?type=5minutefeed\",\n );\n const data: PricePoint[] = await res.json();\n return calculateHourlyAverages(data);\n}\n\nasync function fetchDayAhead(): Promise {\n const hasData = await fetch(\n \"https://hourlypricing.comed.com/rrtp/ServletFeed?type=hasdaynexttomorrow\",\n ).then((r) => r.text());\n\n if (hasData.trim() !== \"true\") return [];\n\n const raw = await fetch(\n \"https://hourlypricing.comed.com/rrtp/ServletFeed?type=daynexttomorrow\",\n ).then((r) => r.text());\n\n return parseDayAhead(raw);\n}\n\nfunction parseDayAhead(raw: string): HourlyAverage[] {\n const results: HourlyAverage[] = [];\n const pattern =\n /Date\\.UTC\\((\\d+),(\\d+),(\\d+),(\\d+),\\d+,\\d+\\)\\s*,\\s*([-\\d.]+)/g;\n let match;\n\n while ((match = pattern.exec(raw)) !== null) {\n const [, year, month, day, hour, price] = match;\n results.push({\n hour: new Date(\n Date.UTC(\n parseInt(year),\n parseInt(month),\n parseInt(day),\n parseInt(hour),\n ),\n ),\n price: Math.round(parseFloat(price) * 100) / 100,\n });\n }\n\n return results;\n}\n\nfunction calculateHourlyAverages(data: PricePoint[]): HourlyAverage[] {\n const buckets = new Map();\n\n for (const point of data) {\n const date = new Date(parseInt(point.millisUTC));\n const hourKey = [\n date.getUTCFullYear(),\n date.getUTCMonth(),\n date.getUTCDate(),\n date.getUTCHours(),\n ].join(\"-\");\n\n if (!buckets.has(hourKey)) buckets.set(hourKey, []);\n buckets.get(hourKey)!.push(parseFloat(point.price));\n }\n\n const averages: HourlyAverage[] = [];\n for (const [key, prices] of buckets) {\n const [year, month, day, hour] = key.split(\"-\").map(Number);\n const avg = prices.reduce((a, b) => a + b, 0) / prices.length;\n averages.push({\n hour: new Date(Date.UTC(year, month, day, hour)),\n price: Math.round(avg * 100) / 100,\n });\n }\n\n averages.sort((a, b) => a.hour.getTime() - b.hour.getTime());\n return averages;\n}\n\nfunction deduplicateAndMerge(\n historical: HourlyAverage[],\n dayAhead: HourlyAverage[],\n): HourlyAverage[] {\n const byTime = new Map();\n\n // Historical first, day-ahead overwrites any overlap\n for (const h of historical) byTime.set(h.hour.getTime(), h);\n for (const d of dayAhead) byTime.set(d.hour.getTime(), d);\n\n return Array.from(byTime.values()).sort(\n (a, b) => a.hour.getTime() - b.hour.getTime(),\n );\n}\n\nfunction generateICal(\n hourlyPrices: HourlyAverage[],\n thresholdCents: number,\n): string {\n const events: string[] = [];\n\n for (let i = 1; i < hourlyPrices.length; i++) {\n const prev = hourlyPrices[i - 1];\n const curr = hourlyPrices[i];\n const delta = curr.price - prev.price;\n\n if (Math.abs(delta) < thresholdCents) continue;\n\n const direction = delta > 0 ? \"\\u2191\" : \"\\u2193\";\n const sign = delta > 0 ? \"+\" : \"\";\n const fmt = (n: number) => (Object.is(n, -0) ? \"0.0\" : n.toFixed(1));\n const start = formatDateUTC(curr.hour);\n const end = formatDateUTC(new Date(curr.hour.getTime() + 3600000));\n const uid = `comed-${start}@hourlypricing`;\n\n events.push(\n [\n \"BEGIN:VEVENT\",\n `DTSTART:${start}`,\n `DTEND:${end}`,\n `SUMMARY:${direction} ${fmt(curr.price)}c/kWh (${sign}${fmt(delta)}c)`,\n `DESCRIPTION:ComEd price ${delta > 0 ? \"rose\" : \"fell\"} from ${\n fmt(prev.price)\n }c to ${fmt(curr.price)}c per kWh`,\n `UID:${uid}`,\n \"END:VEVENT\",\n ].join(\"\\r\\n\"),\n );\n }\n\n return [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//ComEd Hourly Pricing//joshbeckman.org\",\n \"X-WR-CALNAME:ComEd Electricity Prices\",\n \"X-WR-TIMEZONE:America/Chicago\",\n ...events,\n \"END:VCALENDAR\",\n \"\",\n ].join(\"\\r\\n\");\n}\n\nfunction formatDateUTC(date: Date): string {\n const iso = date.toISOString();\n return iso.slice(0, 4) + iso.slice(5, 7) + iso.slice(8, 13) +\n iso.slice(14, 16) + iso.slice(17, 19) + \"Z\";\n}","deleted","label","children",[],[165],"files",[163],"counts",{"_187":33,"_188":125,"_189":33,"_190":191,"_194":195},"pulls","branches","forks","envVars",{"_192":33,"_193":33},"count","emptyCount","connections",{"_192":33,"_196":33},"unfilledCount","contents",[199],{"_108":164,"_100":165,"_166":167,"_168":-5,"_169":151,"_170":105,"_171":22,"_110":200,"_104":173,"_174":175,"_176":177,"_178":22,"_179":-5,"_103":201},["D",1772326822597],[165],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_106":211,"_104":105,"_216":217},{"_108":109,"_100":101,"_110":212,"_112":-5,"_113":22,"_114":115,"_116":117,"_118":-5,"_14":119,"_120":-5,"_121":22,"_122":-5,"_123":-5,"_124":125,"_16":126,"_127":-5,"_128":-5,"_129":-5,"_130":-5,"_131":132,"_133":132,"_134":135,"_136":135,"_137":135,"_138":132,"_139":132,"_23":213,"_143":214,"_148":215,"_160":22},["D",1772326305620],{"_98":99,"_141":142},{"_98":99,"_145":142,"_14":119,"_146":147},{"_104":150,"_100":46,"_108":151,"_152":109,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":101,"_159":99},"changes",[218],{"_202":219,"_221":222,"_178":22,"_103":165,"_224":165},{"_166":167,"_100":165,"_174":175,"_176":177,"_110":220,"_170":105,"_169":151},["D",1772326822597],"previous",{"_166":167,"_100":165,"_174":175,"_176":223},"type PricePoint = {\n millisUTC: string;\n price: string;\n};\n\ntype HourlyAverage = {\n hour: Date;\n price: number; // cents/kWh\n};\n\nexport default async function (req: Request): Promise {\n const [historicalPrices, dayAheadPrices] = await Promise.all([\n fetchHistoricalHourly(),\n fetchDayAhead(),\n ]);\n\n const allPrices = deduplicateAndMerge(historicalPrices, dayAheadPrices);\n const ical = generateICal(allPrices, 0.1); // $0.001 = 0.1 cents\n\n return new Response(ical, {\n headers: {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Content-Disposition\": 'attachment; filename=\"comed-prices.ics\"',\n },\n });\n}\n\nasync function fetchHistoricalHourly(): Promise {\n const res = await fetch(\n \"https://hourlypricing.comed.com/api?type=5minutefeed\",\n );\n const data: PricePoint[] = await res.json();\n return calculateHourlyAverages(data);\n}\n\nasync function fetchDayAhead(): Promise {\n const hasData = await fetch(\n \"https://hourlypricing.comed.com/rrtp/ServletFeed?type=hasdaynexttomorrow\",\n ).then((r) => r.text());\n\n if (hasData.trim() !== \"true\") return [];\n\n const raw = await fetch(\n \"https://hourlypricing.comed.com/rrtp/ServletFeed?type=daynexttomorrow\",\n ).then((r) => r.text());\n\n return parseDayAhead(raw);\n}\n\nfunction parseDayAhead(raw: string): HourlyAverage[] {\n const results: HourlyAverage[] = [];\n const pattern =\n /Date\\.UTC\\((\\d+),(\\d+),(\\d+),(\\d+),\\d+,\\d+\\)\\s*,\\s*([-\\d.]+)/g;\n let match;\n\n while ((match = pattern.exec(raw)) !== null) {\n const [, year, month, day, hour, price] = match;\n results.push({\n hour: new Date(\n Date.UTC(\n parseInt(year),\n parseInt(month),\n parseInt(day),\n parseInt(hour),\n ),\n ),\n price: Math.round(parseFloat(price) * 100) / 100,\n });\n }\n\n return results;\n}\n\nfunction calculateHourlyAverages(data: PricePoint[]): HourlyAverage[] {\n const buckets = new Map();\n\n for (const point of data) {\n const date = new Date(parseInt(point.millisUTC));\n const hourKey = [\n date.getUTCFullYear(),\n date.getUTCMonth(),\n date.getUTCDate(),\n date.getUTCHours(),\n ].join(\"-\");\n\n if (!buckets.has(hourKey)) buckets.set(hourKey, []);\n buckets.get(hourKey)!.push(parseFloat(point.price));\n }\n\n const averages: HourlyAverage[] = [];\n for (const [key, prices] of buckets) {\n const [year, month, day, hour] = key.split(\"-\").map(Number);\n const avg = prices.reduce((a, b) => a + b, 0) / prices.length;\n averages.push({\n hour: new Date(Date.UTC(year, month, day, hour)),\n price: Math.round(avg * 100) / 100,\n });\n }\n\n averages.sort((a, b) => a.hour.getTime() - b.hour.getTime());\n return averages;\n}\n\nfunction deduplicateAndMerge(\n historical: HourlyAverage[],\n dayAhead: HourlyAverage[],\n): HourlyAverage[] {\n const byTime = new Map();\n\n // Historical first, day-ahead overwrites any overlap\n for (const h of historical) byTime.set(h.hour.getTime(), h);\n for (const d of dayAhead) byTime.set(d.hour.getTime(), d);\n\n return Array.from(byTime.values()).sort(\n (a, b) => a.hour.getTime() - b.hour.getTime(),\n );\n}\n\nfunction generateICal(\n hourlyPrices: HourlyAverage[],\n thresholdCents: number,\n): string {\n const events: string[] = [];\n\n for (let i = 1; i < hourlyPrices.length; i++) {\n const prev = hourlyPrices[i - 1];\n const curr = hourlyPrices[i];\n const delta = curr.price - prev.price;\n\n if (Math.abs(delta) < thresholdCents) continue;\n\n const direction = delta > 0 ? \"\\u2191\" : \"\\u2193\";\n const sign = delta > 0 ? \"+\" : \"\";\n const fmt = (n: number) => (Object.is(n, -0) ? \"0.0\" : n.toFixed(1));\n const start = formatDateUTC(curr.hour);\n const end = formatDateUTC(new Date(curr.hour.getTime() + 3600000));\n const uid = `comed-${start}@hourlypricing`;\n\n events.push(\n [\n \"BEGIN:VEVENT\",\n `DTSTART:${start}`,\n `DTEND:${end}`,\n `SUMMARY:${direction} ${fmt(curr.price)}c/kWh (${sign}${fmt(delta)}c)`,\n `DESCRIPTION:ComEd price ${delta > 0 ? \"rose\" : \"fell\"} from ${\n fmt(prev.price)\n }c to ${fmt(curr.price)}c per kWh`,\n `UID:${uid}`,\n \"END:VEVENT\",\n ].join(\"\\r\\n\"),\n );\n }\n\n return [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//ComEd Hourly Pricing//joshbeckman.org\",\n \"X-WR-CALNAME:ComEd Electricity Prices\",\n \"X-WR-TIMEZONE:America/Chicago\",\n ...events,\n \"END:VCALENDAR\",\n \"\",\n ].join(\"\\r\\n\");\n}\n\nfunction formatDateUTC(date: Date): string {\n return date\n .toISOString()\n .replace(/[-:]/g, \"\")\n .replace(/\\.\\d{3}/, \"\");\n}","latestPath","actionData","errors"]