mathisve

## works for ubuntu
## source: https://www.linuxtechi.com/install-kubernetes-on-ubuntu-22-04/

sudo swapoff -a
sudo sed -i '/ swap / s/^\(.*\)$/#\1/g' /etc/fstab

sudo tee /etc/modules-load.d/containerd.conf <<EOF
overlay
br_netfilter
EOF

mathisve

--DROP MATERIALIZED VIEW tick1mcagg, tick10mcagg, tick30mcagg, tick1hcagg, tick6hcagg, tick12hcagg, tick1dcagg, tick7dcagg, tick14dcagg, tick30dcagg;
--DROP MATERIALIZED VIEW fl1mcagg, fl10mcagg, fl30mcagg, fl1hcagg, fl6hcagg, fl12hcagg, fl1dcagg, fl7dcagg, fl14dcagg, fl30dcagg;

--tickcaggs
CREATE MATERIALIZED VIEW tick1mcagg WITH (timescaledb.continuous) AS                                                                                                           
SELECT time_bucket('1m', time) as time, avg(price) as price, symbol
FROM crypto_ticks                                                                                                                          
GROUP BY time_bucket('1m', time), symbol WITH NO DATA;

CREATE MATERIALIZED VIEW tick10mcagg WITH (timescaledb.continuous) AS

mathisve

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "grafana",
          "uid": "-- Grafana --"
        },
        "enable": true,