Skip to content

Instantly share code, notes, and snippets.

View ereshzealous's full-sized avatar

Eresh ereshzealous

42 followers · 1 following
View GitHub Profile
@ereshzealous
ereshzealous / gist:0533a74715f1fc1fc7602c48196159c4
Created September 21, 2023 05:17
Talisman.txt
# Download the talisman installer script
curl https://thoughtworks.github.io/talisman/install.sh > ~/install-talisman.sh
chmod +x ~/install-talisman.sh
# Install to a single project
cd <project-folder>
# as a pre-push hook
@ereshzealous
ereshzealous / Talisman.md
Last active September 7, 2023 04:38
Talisman on single repo
@ereshzealous
ereshzealous / yearly-aggregate.flux
Created March 15, 2022 07:36
data = from(bucket: "daily-aggregate")
|> range(start: -1y)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(every: 1y)
max = data
|> filter(fn: (r) => r["_field"] == "max")
|> max()
@ereshzealous
ereshzealous / yearly-whole-dataset.flux
Created March 15, 2022 07:35
from(bucket: "local")
|> range(start: -1y)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> aggregateWindow(every: 1y, fn: max, createEmpty: false)
|> yield(name: "max")
from(bucket: "local")
|> range(start: -1y)
@ereshzealous
ereshzealous / Period-168.flux
Created March 15, 2022 07:31
from(bucket: "local")
|> range(start: -37d, stop: now())
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(period: 1h)
|> first()
|> yield(name: "first")
@ereshzealous
ereshzealous / period24.flux
Created March 15, 2022 07:27
from(bucket: "local")
|> range(start: -30d, stop: now())
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(period: 1h)
|> first()
|> yield(name: "first")
@ereshzealous
ereshzealous / 7day-1month-daily-aggregate.txt
Created March 15, 2022 07:26
data = from(bucket: "daily-aggregate")
|> range(start: -30d)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(every: 1w) min = data
|> min()
|> set(key: "type", value: "min" ) max = data
@ereshzealous
ereshzealous / 7day-1month-union.txt
Created March 15, 2022 07:21
data = from(bucket: "local")
|> range(start: -30d)
|> filter(fn: (r) => r["_measurement"] == "ticks")
|> filter(fn: (r) => r["_field"] == "price")
|> filter(fn: (r) => r["product"] == "AGUX/USD")
|> window(every: 1w) min = data
|> min()
|> set(key: "type", value: "min" ) max = data
@ereshzealous
ereshzealous / continous-query.txt
Created March 15, 2022 07:01
option task = {name: "daily_aggregate", every: 1d}
max = from(bucket: "local")
|> range(start: -1y)
|> filter(fn: (r) =>
(r["_measurement"] == "ticks"))
|> filter(fn: (r) =>
(r["_field"] == "price"))
|> aggregateWindow(every: 1d, fn: max, createEmpty: false)
@ereshzealous
ereshzealous / Daily-aggregate-union.flux
Created March 15, 2022 06:33
data = from(bucket: "daily-aggregate")
|> range(start: -1d) |> filter(fn: (r) => r["_measurement"] == "ticks") |> filter(fn: (r) => r["product"] == "AGUX/USD") |> window(every: 1d) max = data
|> filter(fn: (r) => r["_field"] == "max") |> max()
|> set(key: "type", value: "max" ) min = data
|> filter(fn: (r) => r["_field"] == "min") |> min()
|> set(key: "type", value: "min" ) union(tables: [min, max])
|> group(columns:["type"], mode: "by")
|> yield()