pico_reliability.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import io\n",
    "import zipfile\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from typing import List\n",
    "from fastapi import FastAPI\n",
    "from fastapi.middleware.cors import CORSMiddleware\n",
    "from fastapi.responses import StreamingResponse\n",
    "import dotenv\n",
    "import pendulum\n",
    "from datetime import timedelta\n",
    "from pydantic import BaseModel\n",
    "from sqlalchemy import create_engine, asc, or_\n",
    "from sqlalchemy.orm import sessionmaker\n",
    "from fake_config import Settings\n",
    "from fake_models import MessageSql\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "settings = Settings(_env_file=dotenv.find_dotenv())\n",
    "valid_password = settings.visualizer_api_password.get_secret_value()\n",
    "engine = create_engine(settings.db_url.get_secret_value())\n",
    "Session = sessionmaker(bind=engine)\n",
    "session = Session()\n",
    "\n",
    "house_alias = 'fir'\n",
    "timezone = \"America/New_York\"\n",
    "start = pendulum.datetime(2024, 11, 5, 0, 0, tz=timezone)\n",
    "end = pendulum.datetime(2024, 11, 6, 23, 30, tz=timezone)\n",
    "start_ms = int(start.timestamp() * 1000)\n",
    "end_ms = int(end.timestamp() * 1000)\n",
    "\n",
    "messages = session.query(MessageSql).filter(\n",
    "    # MessageSql.from_alias.like(f'%{house_alias}%'),\n",
    "    MessageSql.message_type_name == \"gridworks.event.problem\",\n",
    "    MessageSql.message_persisted_ms >= start_ms,\n",
    "    MessageSql.message_persisted_ms <= end_ms,\n",
    ").order_by(asc(MessageSql.message_persisted_ms)).all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error in fir at time 2024-11-05T14:47:56.576000+00:00\n",
      "Error in fir at time 2024-11-05T14:47:56.597000+00:00\n",
      "Error in fir at time 2024-11-05T14:47:56.604000+00:00\n",
      "Error in fir at time 2024-11-06T21:52:36.932000+00:00\n",
      "Error in fir at time 2024-11-06T21:52:36.957000+00:00\n",
      "Error in fir at time 2024-11-06T21:52:36.963000+00:00\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAiwAAAGdCAYAAAAxCSikAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8fJSN1AAAACXBIWXMAAA9hAAAPYQGoP6dpAAAjA0lEQVR4nO3de1DVZeLH8c9REGjjnFACRTG1JsM1LbFRMKdsCjQlrWbTXdfLbjlLm3mfVYzWfjrKlmZumXfR3N3RNk3Hklyx8lJShIFjXjMvEEIKGgd1FxC+vz8cznRCkMNFHk7v18yZWZ7znO/3eWTne957LqzNsixLAAAABmvR1AsAAAC4EYIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPF8mnoBDaWiokJnz55VYGCgbDZbUy8HAADUgmVZKi4uVlhYmFq0qP51FK8JlrNnzyo8PLyplwEAAOogJydHHTp0qPZ+rwmWwMBASdc2bLfbm3g1AACgNpxOp8LDw13P49XxmmCpfBvIbrcTLAAANDM3+jgHH7oFAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyPg2XPnj2Ki4tTWFiYbDabtmzZcsPH7N69W5GRkfL391eXLl20bNmyaudu2LBBNptNw4YN83RpAADAS3kcLJcvX1bPnj21ePHiWs0/deqUHn/8cfXv31+ZmZmaOXOmJkyYoE2bNlWZe+bMGU2bNk39+/f3dFkAAMCL+Xj6gEGDBmnQoEG1nr9s2TJ17NhRixYtkiRFREQoIyNDCxYs0NNPP+2aV15erpEjR+r//u//tHfvXv3444+eLg0AAHipRv8MS1pammJiYtzGYmNjlZGRobKyMtfY7Nmzdfvtt+vZZ5+t1XFLSkrkdDrdbgAAwDs1erDk5+crNDTUbSw0NFRXr15VQUGBJOnzzz/X6tWrtXLlylofNykpSQ6Hw3ULDw9v0HUDAABz3JRvCdlsNrefLctyjRcXF+v3v/+9Vq5cqeDg4FofMyEhQUVFRa5bTk5Og64ZAACYw+PPsHiqbdu2ys/Pdxs7d+6cfHx81KZNGx06dEinT59WXFyc6/6Kiopri/Px0bFjx3TnnXdWOa6fn5/8/Pwad/EAAMAIjR4sUVFR+uCDD9zGduzYod69e8vX11f33HOPDh486HZ/YmKiiouL9fe//523egAAgOfBcunSJZ04ccL186lTp5SVlaXWrVurY8eOSkhIUG5urtatWydJio+P1+LFizVlyhSNGzdOaWlpWr16tdavXy9J8vf3V/fu3d3Ocdttt0lSlXEAAPDL5HGwZGRkaMCAAa6fp0yZIkkaM2aM1q5dq7y8PGVnZ7vu79y5s1JSUjR58mS9/fbbCgsL05tvvun2lWYAAICa2KzKT8A2c06nUw6HQ0VFRbLb7U29HAAAUAu1ff7m/0sIAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyPg2XPnj2Ki4tTWFiYbDabtmzZcsPH7N69W5GRkfL391eXLl20bNkyt/tXrlyp/v37KygoSEFBQXr00UeVnp7u6dIAAICX8jhYLl++rJ49e2rx4sW1mn/q1Ck9/vjj6t+/vzIzMzVz5kxNmDBBmzZtcs3ZtWuXfvvb3+rTTz9VWlqaOnbsqJiYGOXm5nq6PAAA4IVslmVZdX6wzabNmzdr2LBh1c6ZPn26tm7dqiNHjrjG4uPjdeDAAaWlpV33MeXl5QoKCtLixYs1evToWq3F6XTK4XCoqKhIdrvdo30AAICmUdvn70b/DEtaWppiYmLcxmJjY5WRkaGysrLrPubKlSsqKytT69atqz1uSUmJnE6n2w0AAHinRg+W/Px8hYaGuo2Fhobq6tWrKigouO5jZsyYofbt2+vRRx+t9rhJSUlyOByuW3h4eIOuGwAAmOOmfEvIZrO5/Vz5LtTPxyXptdde0/r16/X+++/L39+/2mMmJCSoqKjIdcvJyWnYRQMAAGP4NPYJ2rZtq/z8fLexc+fOycfHR23atHEbX7BggebNm6edO3eqR48eNR7Xz89Pfn5+Db5eAABgnkZ/hSUqKkqpqaluYzt27FDv3r3l6+vrGps/f77mzJmj7du3q3fv3o29LAAA0Ix4HCyXLl1SVlaWsrKyJF372nJWVpays7MlXXur5qff7ImPj9eZM2c0ZcoUHTlyRMnJyVq9erWmTZvmmvPaa68pMTFRycnJ6tSpk/Lz85Wfn69Lly7Vc3sAAMAbePy15l27dmnAgAFVxseMGaO1a9dq7NixOn36tHbt2uW6b/fu3Zo8ebIOHTqksLAwTZ8+XfHx8a77O3XqpDNnzlQ55qxZs/TKK6/Ual18rRkAgOants/f9fo7LCYhWAAAaH6M+TssAAAA9UWwAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4Pk29AJP9t7Rc81IO63ThFXVqc4tmPt5NAa1aNvWyAAC4aUx5LvT4FZY9e/YoLi5OYWFhstls2rJlyw0fs3v3bkVGRsrf319dunTRsmXLqszZtGmTunXrJj8/P3Xr1k2bN2/2dGkNaty6rxTx1+36xxfZ2vttgf7xRbYi/rpd49Z91aTrAgDgZjHpudDjYLl8+bJ69uypxYsX12r+qVOn9Pjjj6t///7KzMzUzJkzNWHCBG3atMk1Jy0tTcOHD9eoUaN04MABjRo1Ss8884y+/PJLT5fXIMat+0qph89d977Uw+eIFgCA1zPtudBmWZZV5wfbbNq8ebOGDRtW7Zzp06dr69atOnLkiGssPj5eBw4cUFpamiRp+PDhcjqd+uijj1xzBg4cqKCgIK1fv75Wa3E6nXI4HCoqKpLdbq/bhnTtpa+Iv26/4bwjswfy9hAAwCvdzOfC2j5/N/qHbtPS0hQTE+M2Fhsbq4yMDJWVldU4Z9++fdUet6SkRE6n0+3WEOalHG7QeQAANDcmPhc2erDk5+crNDTUbSw0NFRXr15VQUFBjXPy8/OrPW5SUpIcDofrFh4e3iDrPV14pUHnAQDQ3Jj4XHhTvtZss9ncfq58F+qn49eb8/Oxn0pISFBRUZHrlpOT0yBr7dTmlgadBwBAc2Pic2GjB0vbtm2rvFJy7tw5+fj4qE2bNjXO+fmrLj/l5+cnu93udmsIMx/v1qDzAABobkx8Lmz0YImKilJqaqrb2I4dO9S7d2/5+vrWOCc6Orqxl1dFQKuWeqxbSI1zHusWwgduAQBey8TnQo+D5dKlS8rKylJWVpaka19bzsrKUnZ2tqRrb9WMHj3aNT8+Pl5nzpzRlClTdOTIESUnJ2v16tWaNm2aa87EiRO1Y8cOvfrqqzp69KheffVV7dy5U5MmTarf7upo5egHqv1FPdYtRCtHP3CTVwQAwM1l2nOhx19r3rVrlwYMGFBlfMyYMVq7dq3Gjh2r06dPa9euXa77du/ercmTJ+vQoUMKCwvT9OnTFR8f7/b4jRs3KjExUSdPntSdd96puXPn6qmnnqr1uhrqa80/Zcpf9wMAoKk09nNhbZ+/6/V3WEzSGMECAAAalzF/hwUAAKC+CBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxiNYAACA8QgWAABgPIIFAAAYj2ABAADGI1gAAIDxCBYAAGA8ggUAABiPYAEAAMYjWAAAgPEIFgAAYDyCBQAAGI9gAQAAxqtTsCxZskSdO3eWv7+/IiMjtXfv3hrnv/3224qIiFBAQIC6du2qdevWVZmzaNEide3aVQEBAQoPD9fkyZP1v//9ry7LAwAAXsbH0we8++67mjRpkpYsWaJ+/fpp+fLlGjRokA4fPqyOHTtWmb906VIlJCRo5cqVeuCBB5Senq5x48YpKChIcXFxkqR//etfmjFjhpKTkxUdHa3jx49r7NixkqQ33nijfjsEAADNns2yLMuTB/Tp00e9evXS0qVLXWMREREaNmyYkpKSqsyPjo5Wv379NH/+fNfYpEmTlJGRoc8++0ySNH78eB05ckQff/yxa87UqVOVnp5+w1dvKjmdTjkcDhUVFclut3uyJQAA0ERq+/zt0VtCpaWl2r9/v2JiYtzGY2JitG/fvus+pqSkRP7+/m5jAQEBSk9PV1lZmSTpwQcf1P79+5Weni5JOnnypFJSUjR48GBPlgcAALyUR28JFRQUqLy8XKGhoW7joaGhys/Pv+5jYmNjtWrVKg0bNky9evXS/v37lZycrLKyMhUUFKhdu3YaMWKEzp8/rwcffFCWZenq1at6/vnnNWPGjGrXUlJSopKSEtfPTqfTk60AAIBmpE4furXZbG4/W5ZVZazSyy+/rEGDBqlv377y9fXV0KFDXZ9PadmypSRp165dmjt3rpYsWaKvv/5a77//vj788EPNmTOn2jUkJSXJ4XC4buHh4XXZCgAAaAY8Cpbg4GC1bNmyyqsp586dq/KqS6WAgAAlJyfrypUrOn36tLKzs9WpUycFBgYqODhY0rWoGTVqlJ577jnde++9evLJJzVv3jwlJSWpoqLiusdNSEhQUVGR65aTk+PJVgAAQDPiUbC0atVKkZGRSk1NdRtPTU1VdHR0jY/19fVVhw4d1LJlS23YsEFDhgxRixbXTn/lyhXXf67UsmVLWZal6j4T7OfnJ7vd7nYDAADeyeOvNU+ZMkWjRo1S7969FRUVpRUrVig7O1vx8fGSrr3ykZub6/pbK8ePH1d6err69OmjixcvauHChfrmm2/0zjvvuI4ZFxenhQsX6v7771efPn104sQJvfzyy3riiSdcbxsBAIBfLo+DZfjw4SosLNTs2bOVl5en7t27KyUlRXfccYckKS8vT9nZ2a755eXlev3113Xs2DH5+vpqwIAB2rdvnzp16uSak5iYKJvNpsTEROXm5ur2229XXFyc5s6dW/8dAgCAZs/jv8NiKv4OCwAAzU+j/B0WAACApkCwAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxXp2BZsmSJOnfuLH9/f0VGRmrv3r01zn/77bcVERGhgIAAde3aVevWrasy58cff9QLL7ygdu3ayd/fXxEREUpJSanL8gAAgJfx8fQB7777riZNmqQlS5aoX79+Wr58uQYNGqTDhw+rY8eOVeYvXbpUCQkJWrlypR544AGlp6dr3LhxCgoKUlxcnCSptLRUjz32mEJCQrRx40Z16NBBOTk5CgwMrP8OAQBAs2ezLMvy5AF9+vRRr169tHTpUtdYRESEhg0bpqSkpCrzo6Oj1a9fP82fP981NmnSJGVkZOizzz6TJC1btkzz58/X0aNH5evrW6eNOJ1OORwOFRUVyW631+kYAADg5qrt87dHbwmVlpZq//79iomJcRuPiYnRvn37rvuYkpIS+fv7u40FBAQoPT1dZWVlkqStW7cqKipKL7zwgkJDQ9W9e3fNmzdP5eXl1a6lpKRETqfT7QYAALyTR8FSUFCg8vJyhYaGuo2HhoYqPz//uo+JjY3VqlWrtH//flmWpYyMDCUnJ6usrEwFBQWSpJMnT2rjxo0qLy9XSkqKEhMT9frrr2vu3LnVriUpKUkOh8N1Cw8P92QrAACgGanTh25tNpvbz5ZlVRmr9PLLL2vQoEHq27evfH19NXToUI0dO1aS1LJlS0lSRUWFQkJCtGLFCkVGRmrEiBF66aWX3N52+rmEhAQVFRW5bjk5OXXZCgAAaAY8Cpbg4GC1bNmyyqsp586dq/KqS6WAgAAlJyfrypUrOn36tLKzs9WpUycFBgYqODhYktSuXTvdfffdroCRrn0uJj8/X6Wlpdc9rp+fn+x2u9sNAAB4J4+CpVWrVoqMjFRqaqrbeGpqqqKjo2t8rK+vrzp06KCWLVtqw4YNGjJkiFq0uHb6fv366cSJE6qoqHDNP378uNq1a6dWrVp5skQAAOCFPH5LaMqUKVq1apWSk5N15MgRTZ48WdnZ2YqPj5d07a2a0aNHu+YfP35c//znP/Xtt98qPT1dI0aM0DfffKN58+a55jz//PMqLCzUxIkTdfz4cW3btk3z5s3TCy+80ABbBAAAzZ3Hf4dl+PDhKiws1OzZs5WXl6fu3bsrJSVFd9xxhyQpLy9P2dnZrvnl5eV6/fXXdezYMfn6+mrAgAHat2+fOnXq5JoTHh6uHTt2aPLkyerRo4fat2+viRMnavr06fXfIQAAaPY8/jsspuLvsAAA0Pw0yt9hAQAAaAoECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeAQLAAAwnk9TL6ChWJYlSXI6nU28EgAAUFuVz9uVz+PV8ZpgKS4uliSFh4c38UoAAICniouL5XA4qr3fZt0oaZqJiooKnT17VoGBgbLZbE29nCqcTqfCw8OVk5Mju93e1MtpNOzTu7BP78I+vYu37NOyLBUXFyssLEwtWlT/SRWveYWlRYsW6tChQ1Mv44bsdnuz/i9WbbFP78I+vQv79C7esM+aXlmpxIduAQCA8QgWAABgPILlJvHz89OsWbPk5+fX1EtpVOzTu7BP78I+vcsvZZ+VvOZDtwAAwHvxCgsAADAewQIAAIxHsAAAAOMRLAAAwHi/uGDZs2eP4uLiFBYWJpvNpi1btlSZ8/777ys2NlbBwcGy2WzKysqq1bEvXryoUaNGyeFwyOFwaNSoUfrxxx/d5thstiq3ZcuW1XjcFStW6OGHH5bdbpfNZqtyzErbtm1Tnz59FBAQIIfDoXbt2jWbfV64cEEvvviiunbtqltuuUUdO3bUhAkTVFRUdMNzb9u2rUl/p5K0du1a9ejRQ/7+/mrbtq3Gjx9f43FLSkr04osvKjg4WL/61a/0xBNP6Pvvv6/x3DExMRo4cKDX7fOnc++77z7ZbDY99NBDXrfP48ePa+jQoQoODpbdblf37t0VFRXVrPZ5o2vR6dOn9eyzz6pz584KCAjQnXfeqbFjx2rw4MFetc9KJl1zPd1nfa651f17NLZfXLBcvnxZPXv21OLFi2uc069fP/3tb3/z6Ni/+93vlJWVpe3bt2v79u3KysrSqFGjqsxbs2aN8vLyXLcxY8bUeNwrV65o4MCBmjlzZrVzNm3apFGjRukPf/iDDhw4oAULFig6OrrZ7PPs2bM6e/asFixYoIMHD2rt2rXavn27nn322Ruee/bs2U36O124cKFeeuklzZgxQ4cOHdLHH3+s2NjYGo87adIkbd68WRs2bNBnn32mS5cuaciQISovL6/23MePH9d3333ndfus9Je//EVhYWGSpLvvvtvr9jl48GBdvXpVn3zyifbv369OnTopIyNDc+bMaTb7vNG16OjRo6qoqNDy5ct16NAhvfHGG9qyZYsKCwub1e+zOV5zPd1nfa6517ve3xTWL5gka/PmzdXef+rUKUuSlZmZecNjHT582JJkffHFF66xtLQ0S5J19OjRWp+zJp9++qklybp48aLbeFlZmdW+fXtr1apV131cc9tnpX//+99Wq1atrLKyslqf+2bv9cKFC1ZAQIC1c+fOWu/rxx9/tHx9fa0NGza4xnJzc60WLVpY27dvr9W5vWWflVJSUqx77rnHOnTokNu6vWWf58+ftyRZe/bscc1xOp2WJGvnzp3NYp8/Vd216Hpee+01q3PnzpZlNY/f5081l2tuffdZqS7X3JvpF/cKS2NJS0uTw+FQnz59XGN9+/aVw+HQvn373OaOHz9ewcHBeuCBB7Rs2TJVVFTU69xff/21cnNz1aJFC91///1q166dBg0apEOHDtXruNdzM/dZVFQku90uHx8fj8/dEGpzvtTUVFVUVCg3N1cRERHq0KGDnnnmGeXk5FR73P3796usrEwxMTGusbCwMHXv3t113Ju516bcpyT98MMPGjdunP7xj3/olltuadC9/VRT7rNNmzaKiIjQunXrdPnyZV29elXLly9XaGioIiMjm8U+66qoqEitW7du8OM25T5Nu+Y21D6b+pp7IwRLA8nPz1dISEiV8ZCQEOXn57t+njNnjt577z3t3LlTI0aM0NSpUzVv3rx6nfvkyZOSpFdeeUWJiYn68MMPFRQUpIceekgXLlyo17F/7mbts7CwUHPmzNGf/vQnj8/dUGpzvpMnT6qiokLz5s3TokWLtHHjRl24cEGPPfaYSktLqz1uq1atFBQU5DYeGhrqOu7N3GtT7tOyLI0dO1bx8fHq3bt3g+7reutpqn3abDalpqYqMzNTgYGB8vf31xtvvKHt27frtttuaxb7rIvvvvtOb731luLj4xvsmJWacp+mXXMbYp8mXHNvhGCpg/j4eN16662uWyWbzVZlrmVZbuOJiYmKiorSfffdp6lTp2r27NmaP39+vdZT+crFSy+9pKefflqRkZFas2aNbDab3nvvvToft6n26XQ6NXjwYHXr1k2zZs1yu682566Luu61oqJCZWVlevPNNxUbG6u+fftq/fr1+vbbb/Xpp596tIaf76Mx9mraPt966y05nU4lJCTUeU/XY9o+LcvSn//8Z4WEhGjv3r1KT0/X0KFDNWTIEOXl5TXrfVbn7NmzGjhwoH7zm9/oueeeq9exTNunadfc+u6zKa65deFz08/oBWbPnq1p06a5jbVt21Y//PBDlbnnz59XaGhotcfq27evnE6nfvjhhxrn1aRdu3aSpG7durnG/Pz81KVLF2VnZ9fpmFLT7LO4uFgDBw7Urbfeqs2bN8vX17fe566Nuu71ev/2t99+u4KDg6v9t2/btq1KS0t18eJFt/9Vfu7cOUVHR9f63HVh2j4/+eQTffHFF1X+v1B69+6tkSNH1mGH15i4zw8//FAXL16U3W6XJC1ZskSpqal65513msU+PXH27FkNGDBAUVFRWrFiRb2PZ9o+Tbvm1mefTXXNrQteYamDkJAQ3XXXXa6bJEVFRamoqEjp6emueV9++aWKiopcF63ryczMlL+/f71eFo6MjJSfn5+OHTvmGisrK9Pp06d1xx131Pm4N3ufTqdTMTExatWqlbZu3Sp/f3+3++t67tqo61779esnSW7/9hcuXFBBQUG1//aRkZHy9fVVamqqaywvL0/ffPON67iNtVfT9vnmm2/qwIEDysrKUlZWllJSUiRJ7777rubOnes1+7xy5YokqUUL90tuixYt6vUZtpu5z9rKzc3Vww8/rF69emnNmjVV9lwXpu3TtGtuXffZlNfcOrnpH/NtYsXFxVZmZqaVmZlpSbIWLlxoZWZmWmfOnHHNKSwstDIzM61t27ZZkqwNGzZYmZmZVl5eXo3HHjhwoNWjRw8rLS3NSktLs+69915ryJAhrvu3bt1qrVixwjp48KB14sQJa+XKlZbdbrcmTJhQ43Hz8vKszMxMa+XKla5vGmRmZlqFhYWuORMnTrTat29v/ec//7GOHj1qjR492goKCrJ2797dLPbpdDqtPn36WPfee6914sQJKy8vz3W7evVqjeceOHBgk/1OLcuyhg4dav3617+2Pv/8c+vgwYPWkCFDrG7dulmlpaXVHjc+Pt7q0KGDtXPnTuvrr7+2HnnkEatnz5417rVbt25W//79vW6fP1X57YnKdXvLPs+fP2+1adPGeuqpp6ysrCzr2LFj1oQJEywfHx9rw4YNzWafN7oW5ebmWnfddZf1yCOPWN9//72Vl5dnnThxwkpNTW1Wv8/mds2tyz7rc839+blvll9csFR+Te3ntzFjxrjmrFmz5rpzZs2aVeOxCwsLrZEjR1qBgYFWYGCgNXLkSLevw3300UfWfffdZ916663WLbfcYnXv3t1atGiR6ytk1Zk1a9Z117NmzRrXnNLSUmvq1KlWSEiIFRgYaPXq1atZ7bO634sk69SpUzWe+4MPPmiyvVqWZRUVFVl//OMfrdtuu81q3bq19eSTT1rZ2dk1Hve///2vNX78eKt169ZWQECANWTIkCqP+fm5H330Ua/c509VBos37vOrr76yYmJirNatW1uBgYFWREREs9vnja5F1a3X2/ZpWWZdc+uyz/pcc2vzdfbGYLMsyxIAAIDB+AwLAAAwHsECAACMR7AAAADjESwAAMB4BAsAADAewQIAAIxHsAAAAOMRLAAAwHgECwAAMB7BAgAAjEewAAAA4xEsAADAeP8Pcebg8ztv7oUAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "error_messages = []\n",
    "for message in messages:\n",
    "    error_messages.append(pendulum.from_timestamp(message.message_persisted_ms/1000))\n",
    "    print(f\"Error in {message.from_alias.split('.')[-2]} at time {error_messages[-1]}\")\n",
    "\n",
    "plt.scatter(error_messages, [1]*len(error_messages)) \n",
    "# plt.xlim([pendulum.from_timestamp(start_ms/1000),\n",
    "        #   pendulum.from_timestamp(end_ms/1000)])\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "adda",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}