napkin-0.5.13
Copyright(c) Soostone Inc 2020
LicenseAllRightsReserved
Stabilityexperimental
PortabilityPOSIX
Safe HaskellNone
LanguageHaskell2010

Napkin.Untyped.Ops.Timescale

Description

 
Synopsis

Hyperfunctions

histogram :: SExp_ "value :: any value" -> SExp_ "min :: numeric" -> SExp_ "max :: numeric" -> SExp_ "nbuckets :: integer" -> SExp #

timeBucket :: SExp_ "bucket_width :: interval" -> SExp_ "ts :: timestamp" -> SExp #

https://docs.timescale.com/api/latest/hyperfunctions/time_bucket/ Use time_bucket_interval or time_bucket_integer if you need to pass more arguments.

timeBucketInterval :: SExp_ "bucket_width :: interval" -> SExp_ "ts :: timestamp" -> SExp_ "offset :: interval" -> Maybe (SExp_ "origin :: timestamp") -> SExp #

timeBucketInteger :: SExp_ "bucket_width :: interval" -> SExp_ "ts :: timestamp" -> SExp_ "offset :: interval" -> SExp #

Approximate count distincts

Statistical aggregates

Statistical Aggregates

statsRollup :: SExp_ "hyperloglog | StatsSummary1D | StatsSummary2D" -> SExp_ "hyperloglog | StatsSummary1D | StatsSummary2D" #

statsRolling :: SExp_ "StatsSummary1D | StatsSummary2D" -> WOver -> Maybe NullStrategy -> SExp_ "StatsSummary1D | StatsSummary2D" #

Stats Agg 1D/2D Accessors

statsKurtosis :: SExp_ "summary :: StatsSummary1D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsKurtosisY :: SExp_ "summary :: StatsSummary1D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsKurtosisX :: SExp_ "summary :: StatsSummary1D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsSkewness :: SExp_ "summary :: StatsSummary2D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsSkewnessY :: SExp_ "summary :: StatsSummary2D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsSkewnessX :: SExp_ "summary :: StatsSummary2D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsStddev :: SExp_ "summary :: StatsSummary1D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsStddevX :: SExp_ "summary :: StatsSummary2D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsStddevY :: SExp_ "summary :: StatsSummary2D" -> Maybe (SExp_ "method") -> SExp_ "double precision" #

statsSumX :: SExp_ "summary :: StatsSummary2D" -> SExp_ "double precision" #

statsSumY :: SExp_ "summary :: StatsSummary2D" -> SExp_ "double precision" #

statsVarianceX :: SExp_ "summary :: StatsSummary2D" -> SExp_ "double precision" #

statsVarianceY :: SExp_ "summary :: StatsSummary2D" -> SExp_ "double precision" #

Gapfilling and interpolation

timeBucketGapfill :: SExp_ "bucket_width :: interval | integer" -> SExp_ "time :: timestamp | integer" -> Maybe (SExp_ "start :: timestamp | integer", SExp_ "finish :: timestamp | integer") -> SExp #

locf :: SExp_ "value :: any element" -> Maybe (SExp_ "prev :: expression", Maybe (SExp_ "treat_null_as_missing :: boolean")) -> SExp #

Percentile approximation

percentileUddsketch :: SExp_ "size :: integer" -> SExp_ "max_error :: double precision" -> SExp_ "value :: double precision" -> SExp_ "uddsketch" #

Counter aggregation

counterCounterAgg :: SExp_ "ts :: timestampz" -> SExp_ "value :: double precision" -> Maybe (SExp_ "bounds :: tstzrange") -> SExp_ "CounterSummary" #

counterWithBounds :: SExp_ "summary :: CounterSummary" -> SExp_ "bounds :: tstzrange" -> SExp_ "CounterSummary" #

Time weighted averages

timeWeight :: SExp_ "method" -> SExp_ "ts :: timestampz" -> SExp_ "value :: double precision" -> SExp_ "TimeWeightSummary" #

Downsample

asapSmooth :: SExp_ "ts :: timestampz" -> SExp_ "value :: double precision" -> SExp_ "resolution :: int" -> SExp_ "NormalizedTimevector" #

lltb :: SExp_ "ts :: timestampz" -> SExp_ "value :: double precision" -> SExp_ "resolution :: int" -> SExp_ "SortedTimevector" #