{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Command Line Examples" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Usage: epicsarchiver [OPTIONS] COMMAND [ARGS]...\n", "\n", " Command line tool for interacting with the archiver.\n", "\n", "Options:\n", " --version Show the version and exit.\n", " -h, --hostname TEXT Achiver Appliance hostname or IP [default: localhost]\n", " --help Show this message and exit.\n", "\n", "Commands:\n", " get Print out data from an archiver cluster.\n", " ioc-check Print out statistics of a single IOC from an archiver cluster.\n", " stats Print out statistics from an archiver cluster.\n" ] } ], "source": [ "!epicsarchiver --help" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Get Interface" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Usage: epicsarchiver get [OPTIONS] PVS...\n", "\n", " Print out data from an archiver cluster.\n", "\n", " ARGUMENT pvs What pvs to get data of.\n", "\n", " Example usage:\n", "\n", " .. code-block:: console\n", "\n", " epicsarchiver --hostname archiver-01.example.com get PV_NAME1 PV_NAME2\n", "\n", "Options:\n", " --debug Turn on debug logging\n", " -s, --start [%Y-%m-%d|%Y-%m-%dT%H:%M:%S|%Y-%m-%d %H:%M:%S|%Y-%m-%dT%H:%M:%S.%f|%Y-%m-%d %H:%M:%S.%f]\n", " Start time of query [default: 30 seconds\n", " ago]\n", " -e, --end [%Y-%m-%d|%Y-%m-%dT%H:%M:%S|%Y-%m-%d %H:%M:%S|%Y-%m-%dT%H:%M:%S.%f|%Y-%m-%d %H:%M:%S.%f]\n", " End time of query, [default: now]\n", " -p, --processor-name [FIRSTSAMPLE|LASTSAMPLE|FIRSTFILL|LASTFILL|MEAN|MIN|MAX|COUNT|NCOUNT|NTH|MEDIAN|STD|JITTER|IGNOREFLYERS|FLYERS|VARIANCE|POPVARIANCE|KURTOSIS|SKEWNESS|LINEAR|LOESS|OPTIMIZED|OPTIMLASTSAMPLE|CAPLOTBINNING|DEADBAND|ERRORBAR]\n", " PreProcessor to use\n", " \n", " Docs at https://epicsarchiver.readthedocs.io/en/latest/user/userguide.html#processing-of-data\n", " -b, --bin_size INTEGER Bin size (mostly in seconds) for\n", " preprocessor.\n", " --help Show this message and exit.\n" ] } ], "source": [ "!epicsarchiver get --help" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "tags": [ "hide-output" ] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\u001b[3m DTL-010:EMR-TT-001:TempPeriod 2025-01-10 13:28:58 - 2025-01-10 \u001b[0m\n", "\u001b[3m 13:29:28 \u001b[0m\n", "┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━┳━━━━━━━━━━┓\n", "┃\u001b[1m \u001b[0m\u001b[1mTime \u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mValue\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mStatus\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mSeverity\u001b[0m\u001b[1m \u001b[0m┃\n", "┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━━━╇━━━━━━━━━━┩\n", "│ 2025-01-10 13:28:57.981276590+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.081289559+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.121292676+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.261277953+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.311292185+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.361631784+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.401277568+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.451311601+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.501292652+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.541278221+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.591297400+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.641293691+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.681304259+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.821290869+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.871294125+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:58.961284085+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.011291337+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.061283747+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.151292253+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.201294587+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.291303296+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.341299163+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.431301374+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.481298409+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.521292651+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.571647534+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.621297314+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.661293161+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.801292009+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.851293196+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.901642639+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.941294802+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:28:59.991291036+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.041292258+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.081288988+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.131294508+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.181286076+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.221284499+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.321293627+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.361300233+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.411293598+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.461285067+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.511278315+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.551285424+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.601313009+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.651310883+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.691309417+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.741294835+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.791278667+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:00.881281973+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.111628968+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.161294050+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.211295574+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.251297855+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.301289065+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.341293896+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.391300893+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.581298016+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.631305413+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.671291765+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.721297498+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.771644988+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.811272707+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:01.861293779+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.051278735+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.091292634+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.141325290+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.281292011+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.371285014+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.421292646+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.471294123+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.511290866+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.561288838+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.611292037+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.651656812+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.701298248+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.751292053+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.791290041+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.841277199+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.891308213+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.931276986+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.981639358+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.031299177+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.071294958+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.171294896+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.211291217+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.261294535+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.351277896+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.401298691+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.451290232+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.491300235+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.631302073+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.681295891+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.731315952+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.771311175+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.911289067+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:03.961293842+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.051288026+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.101291276+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.151298639+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.191641104+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.241291420+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.291289383+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.331291403+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.381305056+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.431283927+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.471274015+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.611301433+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.661298403+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.711287679+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.751296567+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.851629477+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.891292171+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.941295063+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:04.991285404+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.031275342+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.081291791+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.131279404+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.171287718+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.221280565+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.361296229+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.451286866+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.501294819+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.551289409+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.591295724+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.641303164+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.731644212+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.781279083+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.831289607+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.921290494+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:05.971291573+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.061648654+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.111281842+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.151295099+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.201295088+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.291285817+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.391655301+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.481301506+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.531291380+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.581301276+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.671317718+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.761293013+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.811302757+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.861296402+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:06.901293626+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.001290081+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.091288892+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.181278863+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.231300004+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.281298581+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.321289181+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.461292635+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.511298350+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.561293368+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.601643686+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.651300569+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.701308193+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.741292300+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.791303329+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.841297890+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.881301383+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.981298073+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.121300813+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.161299600+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.211297906+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.261644515+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.351290004+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.401296086+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.441300357+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.491294112+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.581295545+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.631302+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.721299714+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.861295781+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.911285669+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:08.961291717+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.001289962+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.051281328+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.101295567+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.191292146+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.281296377+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.331301300+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.381299933+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.421293893+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.521293733+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.561290993+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.611294753+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.661296744+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.701288065+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.801656158+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.841298535+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.891279632+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:09.941284628+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.031298584+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.081285105+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.121288649+01:00 │ 24.91 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.171296088+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.311300455+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.361286616+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.501289067+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.591296061+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.641291507+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.681649208+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.731297076+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.781292877+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.821431186+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.871299483+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:10.921290429+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.011649584+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.061292571+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.101296549+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.151311764+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.341659904+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.431296838+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.521294059+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.571287985+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.621275320+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.671691334+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.711292524+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.761296051+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.851296955+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.941279294+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:11.991297977+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.041294632+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.091292992+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.181320341+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.231289489+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.271295844+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.321291828+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.371288241+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.411291338+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.461291205+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.511292725+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.651307086+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.691308340+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.791342938+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.831325+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.881678893+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.971297422+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.021293720+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.071296899+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.111291527+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.211653265+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.251292358+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.301296377+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.351321337+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.391299656+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.491294024+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.581336339+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.631344291+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.671342331+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.771288629+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.911279138+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:13.951284543+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.001292697+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.051293999+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.091649+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.141297934+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.231297834+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.281292924+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.371293574+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.421643624+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.471282764+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.611292230+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.651314751+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.701303881+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.751661399+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.891295361+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.931290621+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:14.981288877+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.031291691+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.071288973+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.171310451+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.211294708+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.261295031+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.311294026+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.351290899+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.401292182+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.451297394+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.491290032+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.541292606+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.631649490+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.681297932+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.771298787+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.821298517+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.871309596+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:15.911293579+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.051294737+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.101292979+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.151295847+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.191298895+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.241301186+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.291651521+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.381286607+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.431279926+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.521301679+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.661294940+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.711301614+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.751290878+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.891302402+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.941294008+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:16.991290850+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.031290135+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.131289516+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.271291428+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.321278970+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.411292858+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.501638924+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.601293307+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.641295845+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.691300221+01:00 │ 25.0 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.741287852+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.781309274+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.831627971+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.881290544+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.921283644+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.971288416+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.061303458+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.161671906+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.201301179+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.251276938+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.301289450+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.441285876+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.481301991+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.531300431+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.581291668+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.621295786+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.671295869+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.811293061+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.861286121+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:18.951297686+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.001279548+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.041626409+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.091296499+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.141290136+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.181274981+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.231300164+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.321284323+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.371646709+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.421294378+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.461292218+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.511294617+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.561294996+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.601298945+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.701649+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.741315945+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.841289307+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.881290259+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.931297748+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:19.981297614+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.021340262+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.071331287+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.121334634+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.211291739+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.351295894+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.401296795+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.541282863+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.581644410+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.631285574+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.681300561+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.721307891+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.821296347+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.861285600+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:20.961295698+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.001291296+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.051277692+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.101310766+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.191299591+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.241645762+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.381292337+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.421289525+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.471294808+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.521289246+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.561290402+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.661302230+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.701295571+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.801301375+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.841291662+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.891295528+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:21.981295378+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.031298093+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.081291373+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.121639100+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.171312311+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.221297750+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.261288296+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.311290428+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.401289576+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.501294686+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.551290208+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.591291804+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.681283292+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.731299672+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.781646129+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.831300480+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.871274441+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.921276475+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.011293188+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.061291637+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.151314980+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.201291510+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.251276673+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.291283121+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.341290991+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.391298322+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.481295343+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.531290254+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.621291657+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.711302858+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.811290508+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.851291118+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.901293677+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.951299977+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:23.991656897+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.041279252+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.091291989+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.131290008+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.181293098+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.231297877+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.321630384+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.371295374+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.411292871+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.461290386+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.511285529+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.601295157+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.651644823+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.691277520+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.741305046+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.831289480+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.881293843+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.931289422+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:24.971302863+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.071292210+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.111286337+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.161290946+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.211287962+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.251287941+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.301294956+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.351338767+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.391288887+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.491291214+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.531635852+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.581282515+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.631296795+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.721296550+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.811289907+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.861634324+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.911292936+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:25.951287083+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.001295124+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.051292754+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.091293689+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.191648807+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.231295120+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.331292122+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.421294972+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.511306373+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.561283354+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.611288461+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.701300925+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:26.751292299+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.031294666+01:00 │ 24.98 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.071629835+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.121293872+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.171304871+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.211295774+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.311293893+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.351297088+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.451298389+01:00 │ 24.93 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.491313938+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.541294402+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.591297208+01:00 │ 24.97 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.631294879+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.731643498+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.771290896+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.821293940+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.911292406+01:00 │ 24.95 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.961294121+01:00 │ 24.97 │ 0 │ 0 │\n", "└─────────────────────────────────────┴───────┴────────┴──────────┘\n" ] } ], "source": [ "!epicsarchiver --hostname archiver-linac-04.tn.esss.lu.se get DTL-010:EMR-TT-001:Temp" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\u001b[3m DTL-010:EMR-TT-001:TempPeriod 2025-01-10 13:29:00 - 2025-01-10 \u001b[0m\n", "\u001b[3m 13:29:30 Processor ProcessorName.MIN, 5 seconds \u001b[0m\n", "┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━┳━━━━━━━━━━┓\n", "┃\u001b[1m \u001b[0m\u001b[1mTime \u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mValue\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mStatus\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mSeverity\u001b[0m\u001b[1m \u001b[0m┃\n", "┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━━━╇━━━━━━━━━━┩\n", "│ 2025-01-10 13:28:57.500000+01:00 │ 24.96 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:02.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:07.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:12.500000+01:00 │ 24.91 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:17.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:22.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:27.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "│ 2025-01-10 13:29:32.500000+01:00 │ 24.92 │ 0 │ 0 │\n", "└──────────────────────────────────┴───────┴────────┴──────────┘\n" ] } ], "source": [ "!epicsarchiver --hostname archiver-linac-04.tn.esss.lu.se get DTL-010:EMR-TT-001:Temp -p min -b 5" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\u001b[3m DTL-010:EMR-TT-001:TempPeriod 2025-01-10 13:29:03 - \u001b[0m\n", "\u001b[3m 2025-01-10 13:29:33 Processor ProcessorName.NCOUNT \u001b[0m\n", "┏━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━┳━━━━━━━━━━┓\n", "┃\u001b[1m \u001b[0m\u001b[1mTime \u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mValue\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mStatus\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mSeverity\u001b[0m\u001b[1m \u001b[0m┃\n", "┡━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━━━╇━━━━━━━━━━┩\n", "│ 2025-01-10 13:29:03+01:00 │ 473 │ 0 │ 0 │\n", "└───────────────────────────┴───────┴────────┴──────────┘\n" ] } ], "source": [ "!epicsarchiver --hostname archiver-linac-04.tn.esss.lu.se get DTL-010:EMR-TT-001:Temp -p ncount" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\u001b[3m Period 2024-12-01 12:00:00 - 2024-12-16 12:10:10.100000 Processor \u001b[0m\n", "\u001b[3m ProcessorName.MEDIAN, 6000 seconds \u001b[0m\n", "┏━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┓\n", "┃\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1mDTL-020:EMR-TT-001:Temp\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1m DTL-020:EMR-TT-002:Temp\u001b[0m\u001b[1m \u001b[0m┃\n", "┃\u001b[1m \u001b[0m\u001b[1mTime \u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1m Value\u001b[0m\u001b[1m \u001b[0m┃\u001b[1m \u001b[0m\u001b[1m Value\u001b[0m\u001b[1m \u001b[0m┃\n", "┡━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━┩\n", "│ 2024-12-01 │ 18.01 │ 17.96 │\n", "│ 11:30:00+01:00 │ │ │\n", "│ 2024-12-01 │ 18.01 │ 17.96 │\n", "│ 13:10:00+01:00 │ │ │\n", "│ 2024-12-01 │ 18.01 │ 17.96 │\n", "│ 14:50:00+01:00 │ │ │\n", "│ 2024-12-01 │ 18.01 │ 17.96 │\n", "│ 16:30:00+01:00 │ │ │\n", "│ 2024-12-01 │ 18.0 │ 17.94 │\n", "│ 18:10:00+01:00 │ │ │\n", "│ 2024-12-01 │ 17.98 │ 17.94 │\n", "│ 19:50:00+01:00 │ │ │\n", "│ 2024-12-01 │ 17.98 │ 17.94 │\n", "│ 21:30:00+01:00 │ │ │\n", "│ 2024-12-01 │ 17.98 │ 17.92 │\n", "│ 23:10:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.96 │ 17.92 │\n", "│ 00:50:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.96 │ 17.92 │\n", "│ 02:30:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.96 │ 17.92 │\n", "│ 04:10:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.96 │ 17.91 │\n", "│ 05:50:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.96 │ 17.92 │\n", "│ 07:30:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.94 │ 17.91 │\n", "│ 09:10:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.94 │ 17.89 │\n", "│ 10:50:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.94 │ 17.89 │\n", "│ 12:30:00+01:00 │ │ │\n", "│ 2024-12-02 │ 17.94 │ 17.91 │\n", "│ 14:10:00+01:00 │ │ │\n", "│ 2024-12-02 │ 20.23 │ 20.07 │\n", "│ 15:50:00+01:00 │ │ │\n", "│ 2024-12-02 │ 20.82 │ 20.77 │\n", "│ 17:30:00+01:00 │ │ │\n", "│ 2024-12-02 │ 20.53 │ 20.490000000000002 │\n", "│ 19:10:00+01:00 │ │ │\n", "│ 2024-12-02 │ 20.19 │ 20.16 │\n", "│ 20:50:00+01:00 │ │ │\n", "│ 2024-12-02 │ 19.92 │ 19.88 │\n", "│ 22:30:00+01:00 │ │ │\n", "│ 2024-12-03 │ 19.67 │ 19.64 │\n", "│ 00:10:00+01:00 │ │ │\n", "│ 2024-12-03 │ 19.48 │ 19.43 │\n", "│ 01:50:00+01:00 │ │ │\n", "│ 2024-12-03 │ 19.29 │ 19.27 │\n", "│ 03:30:00+01:00 │ │ │\n", "│ 2024-12-03 │ 19.14 │ 19.12 │\n", "│ 05:10:00+01:00 │ │ │\n", "│ 2024-12-03 │ 19.0 │ 18.98 │\n", "│ 06:50:00+01:00 │ │ │\n", "│ 2024-12-03 │ 18.91 │ 18.88 │\n", "│ 08:30:00+01:00 │ │ │\n", "│ 2024-12-03 │ 21.0 │ 20.86 │\n", "│ 10:10:00+01:00 │ │ │\n", "│ 2024-12-03 │ 22.07 │ 21.95 │\n", "│ 11:50:00+01:00 │ │ │\n", "│ 2024-12-03 │ 22.86 │ 22.73 │\n", "│ 13:30:00+01:00 │ │ │\n", "│ 2024-12-03 │ 23.51 │ 23.39 │\n", "│ 15:10:00+01:00 │ │ │\n", "│ 2024-12-03 │ 23.990000000000002 │ 23.88 │\n", "│ 16:50:00+01:00 │ │ │\n", "│ 2024-12-03 │ 24.37 │ 24.26 │\n", "│ 18:30:00+01:00 │ │ │\n", "│ 2024-12-03 │ 24.67 │ 24.57 │\n", "│ 20:10:00+01:00 │ │ │\n", "│ 2024-12-03 │ 24.89 │ 24.79 │\n", "│ 21:50:00+01:00 │ │ │\n", "│ 2024-12-03 │ 25.05 │ 24.95 │\n", "│ 23:30:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.18 │ 25.07 │\n", "│ 01:10:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.26 │ 25.16 │\n", "│ 02:50:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.310000000000002 │ 25.22 │\n", "│ 04:30:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.36 │ 25.25 │\n", "│ 06:10:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.400000000000002 │ 25.29 │\n", "│ 07:50:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.42 │ 25.330000000000002 │\n", "│ 09:30:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.45 │ 25.35 │\n", "│ 11:10:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.46 │ 25.35 │\n", "│ 12:50:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.47 │ 25.38 │\n", "│ 14:30:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.48 │ 25.39 │\n", "│ 16:10:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.51 │ 25.400000000000002 │\n", "│ 17:50:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.52 │ 25.43 │\n", "│ 19:30:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.53 │ 25.44 │\n", "│ 21:10:00+01:00 │ │ │\n", "│ 2024-12-04 │ 25.54 │ 25.44 │\n", "│ 22:50:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.54 │ 25.45 │\n", "│ 00:30:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.560000000000002 │ 25.45 │\n", "│ 02:10:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.560000000000002 │ 25.46 │\n", "│ 03:50:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.560000000000002 │ 25.46 │\n", "│ 05:30:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.57 │ 25.46 │\n", "│ 07:10:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.650000000000002 │ 25.55 │\n", "│ 08:50:00+01:00 │ │ │\n", "│ 2024-12-05 │ 26.01 │ 25.91 │\n", "│ 10:30:00+01:00 │ │ │\n", "│ 2024-12-05 │ 26.3 │ 26.21 │\n", "│ 12:10:00+01:00 │ │ │\n", "│ 2024-12-05 │ 26.23 │ 26.13 │\n", "│ 13:50:00+01:00 │ │ │\n", "│ 2024-12-05 │ 26.080000000000002 │ 25.98 │\n", "│ 15:30:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.96 │ 25.87 │\n", "│ 17:10:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.87 │ 25.77 │\n", "│ 18:50:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.8 │ 25.71 │\n", "│ 20:30:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.75 │ 25.650000000000002 │\n", "│ 22:10:00+01:00 │ │ │\n", "│ 2024-12-05 │ 25.7 │ 25.61 │\n", "│ 23:50:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.68 │ 25.57 │\n", "│ 01:30:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.650000000000002 │ 25.55 │\n", "│ 03:10:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.63 │ 25.52 │\n", "│ 04:50:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.62 │ 25.51 │\n", "│ 06:30:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.62 │ 25.51 │\n", "│ 08:10:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.61 │ 25.51 │\n", "│ 09:50:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.59 │ 25.5 │\n", "│ 11:30:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.59 │ 25.5 │\n", "│ 13:10:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.61 │ 25.51 │\n", "│ 14:50:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.64 │ 25.54 │\n", "│ 16:30:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.75 │ 25.650000000000002 │\n", "│ 18:10:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.79 │ 25.68 │\n", "│ 19:50:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.77 │ 25.67 │\n", "│ 21:30:00+01:00 │ │ │\n", "│ 2024-12-06 │ 25.75 │ 25.650000000000002 │\n", "│ 23:10:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.73 │ 25.63 │\n", "│ 00:50:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.72 │ 25.62 │\n", "│ 02:30:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.7 │ 25.61 │\n", "│ 04:10:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.7 │ 25.6 │\n", "│ 05:50:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.69 │ 25.6 │\n", "│ 07:30:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.69 │ 25.580000000000002 │\n", "│ 09:10:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.68 │ 25.57 │\n", "│ 10:50:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 12:30:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 14:10:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 15:50:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 17:30:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 19:10:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 20:50:00+01:00 │ │ │\n", "│ 2024-12-07 │ 25.67 │ 25.57 │\n", "│ 22:30:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.67 │ 25.57 │\n", "│ 00:10:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.67 │ 25.57 │\n", "│ 01:50:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.67 │ 25.57 │\n", "│ 03:30:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.67 │ 25.57 │\n", "│ 05:10:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.57 │\n", "│ 06:50:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.57 │\n", "│ 08:30:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.57 │\n", "│ 10:10:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.57 │\n", "│ 11:50:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.580000000000002 │\n", "│ 13:30:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.580000000000002 │\n", "│ 15:10:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.68 │ 25.580000000000002 │\n", "│ 16:50:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.69 │ 25.580000000000002 │\n", "│ 18:30:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.69 │ 25.580000000000002 │\n", "│ 20:10:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.69 │ 25.580000000000002 │\n", "│ 21:50:00+01:00 │ │ │\n", "│ 2024-12-08 │ 25.69 │ 25.580000000000002 │\n", "│ 23:30:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.68 │ 25.580000000000002 │\n", "│ 01:10:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.68 │ 25.57 │\n", "│ 02:50:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.67 │ 25.57 │\n", "│ 04:30:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.650000000000002 │ 25.560000000000002 │\n", "│ 06:10:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.67 │ 25.57 │\n", "│ 07:50:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.63 │ 25.54 │\n", "│ 09:30:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.560000000000002 │ 25.46 │\n", "│ 11:10:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.57 │ 25.46 │\n", "│ 12:50:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.57 │ 25.46 │\n", "│ 14:30:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.59 │ 25.490000000000002 │\n", "│ 16:10:00+01:00 │ │ │\n", "│ 2024-12-09 │ 25.91 │ 25.78 │\n", "│ 17:50:00+01:00 │ │ │\n", "│ 2024-12-09 │ 26.22 │ 26.1 │\n", "│ 19:30:00+01:00 │ │ │\n", "│ 2024-12-09 │ 26.43 │ 26.310000000000002 │\n", "│ 21:10:00+01:00 │ │ │\n", "│ 2024-12-09 │ 26.57 │ 26.45 │\n", "│ 22:50:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.66 │ 26.55 │\n", "│ 00:30:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.72 │ 26.61 │\n", "│ 02:10:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.77 │ 26.650000000000002 │\n", "│ 03:50:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.810000000000002 │ 26.69 │\n", "│ 05:30:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.830000000000002 │ 26.71 │\n", "│ 07:10:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.830000000000002 │ 26.71 │\n", "│ 08:50:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.78 │ 26.67 │\n", "│ 10:30:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.77 │ 26.66 │\n", "│ 12:10:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.810000000000002 │ 26.69 │\n", "│ 13:50:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.84 │ 26.72 │\n", "│ 15:30:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.86 │ 26.75 │\n", "│ 17:10:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.88 │ 26.77 │\n", "│ 18:50:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.900000000000002 │ 26.79 │\n", "│ 20:30:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.92 │ 26.8 │\n", "│ 22:10:00+01:00 │ │ │\n", "│ 2024-12-10 │ 26.93 │ 26.810000000000002 │\n", "│ 23:50:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.810000000000002 │\n", "│ 01:30:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.810000000000002 │\n", "│ 03:10:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.810000000000002 │\n", "│ 04:50:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.82 │\n", "│ 06:30:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.82 │\n", "│ 08:10:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.93 │ 26.82 │\n", "│ 09:50:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.92 │ 26.810000000000002 │\n", "│ 11:30:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.94 │ 26.830000000000002 │\n", "│ 13:10:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.98 │ 26.87 │\n", "│ 14:50:00+01:00 │ │ │\n", "│ 2024-12-11 │ 27.080000000000002 │ 26.94 │\n", "│ 16:30:00+01:00 │ │ │\n", "│ 2024-12-11 │ 27.39 │ 27.25 │\n", "│ 18:10:00+01:00 │ │ │\n", "│ 2024-12-11 │ 26.240000000000002 │ 26.26 │\n", "│ 19:50:00+01:00 │ │ │\n", "│ 2024-12-11 │ 25.75 │ 25.66 │\n", "│ 21:30:00+01:00 │ │ │\n", "│ 2024-12-11 │ 25.85 │ 25.75 │\n", "│ 23:10:00+01:00 │ │ │\n", "│ 2024-12-12 │ 25.830000000000002 │ 25.75 │\n", "│ 00:50:00+01:00 │ │ │\n", "│ 2024-12-12 │ 25.8 │ 25.72 │\n", "│ 02:30:00+01:00 │ │ │\n", "│ 2024-12-12 │ 25.73 │ 25.650000000000002 │\n", "│ 04:10:00+01:00 │ │ │\n", "│ 2024-12-12 │ 25.43 │ 25.36 │\n", "│ 05:50:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.88 │ 24.85 │\n", "│ 07:30:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.71 │ 24.62 │\n", "│ 09:10:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.76 │ 24.66 │\n", "│ 10:50:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.87 │ 24.76 │\n", "│ 12:30:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.73 │ 24.650000000000002 │\n", "│ 14:10:00+01:00 │ │ │\n", "│ 2024-12-12 │ 25.07 │ 24.97 │\n", "│ 15:50:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.78 │ 24.71 │\n", "│ 17:30:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.76 │ 24.69 │\n", "│ 19:10:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.75 │ 24.66 │\n", "│ 20:50:00+01:00 │ │ │\n", "│ 2024-12-12 │ 24.76 │ 24.67 │\n", "│ 22:30:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.82 │ 24.75 │\n", "│ 00:10:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.76 │ 24.69 │\n", "│ 01:50:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.75 │ 24.67 │\n", "│ 03:30:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.76 │ 24.67 │\n", "│ 05:10:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.89 │ 24.86 │\n", "│ 06:50:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.73 │ 24.64 │\n", "│ 08:30:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.75 │ 24.650000000000002 │\n", "│ 10:10:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.810000000000002 │ 24.73 │\n", "│ 11:50:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.810000000000002 │ 24.71 │\n", "│ 13:30:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.82 │ 24.740000000000002 │\n", "│ 15:10:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.830000000000002 │ 24.75 │\n", "│ 16:50:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.97 │ 24.900000000000002 │\n", "│ 18:30:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.91 │ 24.84 │\n", "│ 20:10:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.89 │ 24.82 │\n", "│ 21:50:00+01:00 │ │ │\n", "│ 2024-12-13 │ 24.810000000000002 │ 24.740000000000002 │\n", "│ 23:30:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.78 │ 24.69 │\n", "│ 01:10:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.8 │ 24.71 │\n", "│ 02:50:00+01:00 │ │ │\n", "│ 2024-12-14 │ 25.29 │ 25.17 │\n", "│ 04:30:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.87 │ 24.8 │\n", "│ 06:10:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.8 │ 24.73 │\n", "│ 07:50:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.810000000000002 │ 24.73 │\n", "│ 09:30:00+01:00 │ │ │\n", "│ 2024-12-14 │ 25.03 │ 24.95 │\n", "│ 11:10:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.810000000000002 │ 24.73 │\n", "│ 12:50:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.810000000000002 │ 24.73 │\n", "│ 14:30:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.8 │ 24.73 │\n", "│ 16:10:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.810000000000002 │ 24.73 │\n", "│ 17:50:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.8 │ 24.73 │\n", "│ 19:30:00+01:00 │ │ │\n", "│ 2024-12-14 │ 25.11 │ 24.97 │\n", "│ 21:10:00+01:00 │ │ │\n", "│ 2024-12-14 │ 24.98 │ 24.91 │\n", "│ 22:50:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.87 │ 24.8 │\n", "│ 00:30:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.86 │ 24.79 │\n", "│ 02:10:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.84 │ 24.78 │\n", "│ 03:50:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.82 │ 24.740000000000002 │\n", "│ 05:30:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.830000000000002 │ 24.75 │\n", "│ 07:10:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.830000000000002 │ 24.75 │\n", "│ 08:50:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.78 │ 24.71 │\n", "│ 10:30:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.84 │ 24.76 │\n", "│ 12:10:00+01:00 │ │ │\n", "│ 2024-12-15 │ 25.25 │ 25.12 │\n", "│ 13:50:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.91 │ 24.84 │\n", "│ 15:30:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.89 │ 24.82 │\n", "│ 17:10:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.98 │ 24.900000000000002 │\n", "│ 18:50:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.93 │ 24.87 │\n", "│ 20:30:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.82 │ 24.75 │\n", "│ 22:10:00+01:00 │ │ │\n", "│ 2024-12-15 │ 24.91 │ 24.82 │\n", "│ 23:50:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.810000000000002 │ 24.740000000000002 │\n", "│ 01:30:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.82 │ 24.75 │\n", "│ 03:10:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.84 │ 24.76 │\n", "│ 04:50:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.82 │ 24.75 │\n", "│ 06:30:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.75 │ 24.66 │\n", "│ 08:10:00+01:00 │ │ │\n", "│ 2024-12-16 │ 24.82 │ 24.73 │\n", "│ 09:50:00+01:00 │ │ │\n", "│ 2024-12-16 │ 25.09 │ 25.01 │\n", "│ 11:30:00+01:00 │ │ │\n", "└─────────────────────────┴─────────────────────────┴──────────────────────────┘\n" ] } ], "source": [ "!epicsarchiver --hostname archiver-linac-04.tn.esss.lu.se get DTL-020:EMR-TT-001:Temp DTL-020:EMR-TT-002:Temp -s 2024-12-01T12:00:00 -e 2024-12-16T12:10:10.10 -p MEDIAN -b 6000" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Statistics Interface" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Usage: epicsarchiver stats [OPTIONS] OUTPUT\n", "\n", " Print out statistics from an archiver cluster.\n", "\n", " ARGUMENT output Where to print output detailed statistics.\n", "\n", " Includes PVs that are often dropping events, long disconnected, producing no\n", " events and not configured. Example usage:\n", "\n", " .. code-block:: console\n", "\n", " epicsarchiver --hostname archiver-01.example.com stats output.csv\n", "\n", " By default produces a csv output in the form\n", "\n", " IOC Name, IOC hostname, PV name, Statistic, Statistic Note IOC_NAME,\n", " PV:NAME, BufferOverflow, Dropped 33393 events by BufferOverflow\n", "\n", "Options:\n", " --debug Turn on debug logging\n", " -l, --limit INTEGER Limit size of queries [default: 1000]\n", " -o, --other_hostname TEXT Other Archiver Appliance hostname or IP\n", " [default: localhost]\n", " -cf, --channelfinder TEXT Channel Finder hostname or IP [default:\n", " channelfinder.tn.esss.lu.se] [default:\n", " channelfinder.tn.esss.lu.se]\n", " -t, --time-minimum INTEGER Minimum time since last disconnect in days.\n", " [default: 100]\n", " -mb, --mb-per-day-minimum FLOAT\n", " Minimum storage rate in MB/day [default:\n", " 100]\n", " -c, --connection-drops-minimum INTEGER\n", " Minimum connection drops to see. [default:\n", " 30]\n", " -edm, --events-dropped-minimum INTEGER\n", " Minimum event drops to see. [default: 10]\n", " -i, --ioc TEXT IOC to filter by.\n", " -v, --verbose Verbose output\n", " -d, --config-gitlab-repo PATH Gitlab repo for files with lists of PVs\n", " [default: archiver-appliance/archiver-\n", " appliance-config-aa-linac-prod]\n", " --config-archiver-alias [tn|nin|lab]\n", " Alias of the Archiver cluster chosen via\n", " info tag in IOC Record [default: tn]\n", " --help Show this message and exit.\n" ] } ], "source": [ "!epicsarchiver stats --help" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "tags": [ "hide-output" ] }, "outputs": [], "source": [ "!epicsarchiver --hostname archiver-linac-wf-04.tn.esss.lu.se stats -d archiver-appliance/archiver-appliance-config-aa-waveform --config-archiver-alias lab wf_report_features-demo.csv" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Usage: epicsarchiver ioc-check [OPTIONS] IOC\n", "\n", " Print out statistics of a single IOC from an archiver cluster.\n", "\n", " ARGUMENT IOC Name of IOC to check\n", "\n", "Options:\n", " --debug Turn on debug logging\n", " -cf, --channelfinder TEXT Channel Finder hostname or IP [default:\n", " channelfinder.tn.esss.lu.se] [default:\n", " channelfinder.tn.esss.lu.se]\n", " -d, --config-gitlab-repo PATH Gitlab repo for files with lists of PVs\n", " [default: archiver-appliance/archiver-\n", " appliance-config-aa-linac-prod]\n", " --config-archiver-alias [tn|nin|lab]\n", " Alias of the Archiver cluster chosen via\n", " info tag in IOC Record [default: tn]\n", " -mb, --mb-per-day-minimum FLOAT\n", " Minimum storage rate in MB/day [default:\n", " 100]\n", " --help Show this message and exit.\n" ] } ], "source": [ "!epicsarchiver ioc-check --help" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "tags": [ "hide-output" ] }, "outputs": [], "source": [ "!epicsarchiver --hostname archiver-linac-04.tn.esss.lu.se ioc-check CWS-G02:SC-IOC-001" ] } ], "metadata": { "kernelspec": { "display_name": ".venv", "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.13.1" } }, "nbformat": 4, "nbformat_minor": 2 }