napkin-1.0.0
Safe HaskellNone
LanguageGHC2021

Napkin.Untyped.Ops.Timescale

Synopsis

Hyperfunctions

approximateRowCount :: Ref Table -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/approximate_row_count/

first :: SExp_ "value" -> SExp_ "time" -> SExp #

https://docs.timescale.com/api/latest/hyperfunctions/first/

last :: SExp_ "value" -> SExp_ "time" -> SExp #

https://docs.timescale.com/api/latest/hyperfunctions/last/

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

https://docs.timescale.com/api/latest/hyperfunctions/histogram/

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 #

https://docs.timescale.com/api/latest/hyperfunctions/time_bucket/

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

https://docs.timescale.com/api/latest/hyperfunctions/time_bucket/

Approximate count distincts

hyperloglog :: SExp_ "buckets" -> SExp_ "value" -> SExp_ "hyperloglog" #

https://docs.timescale.com/api/latest/hyperfunctions/approx_count_distincts/hyperloglog/

rollup :: SExp_ "hyperloglog" -> SExp_ "hyperloglog" #

https://docs.timescale.com/api/latest/hyperfunctions/approx_count_distincts/rollup-hyperloglog/

distinctCount :: SExp_ "hyperloglog" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/approx_count_distincts/distinct_count/

stderror :: SExp_ "hyperloglog" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/approx_count_distincts/stderror/

Statistical aggregates

Statistical Aggregates

statsAgg1d :: SExp_ "value" -> SExp_ "StatsSummary1D" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/stats_agg/

statsAgg2d :: SExp_ "Y" -> SExp_ "X" -> SExp_ "StatsSummary2D" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/stats_agg/

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

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/rolling-stats/

Stats Agg 1D/2D Accessors

statsAverage :: SExp_ "summary :: StatsSummary1D" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/average-stats/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/average-stats/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/average-stats/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/kurtosis/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/kurtosis/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/kurtosis/

statsNumVals :: SExp_ "summary :: StatsSummary1D | StatsSummary2D" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/num_vals-stats/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/skewness/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/skewness/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/skewness/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/stddev/

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

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

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/slope-stats/

statsSum :: SExp_ "summary :: StatsSummary1D" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/sum-stats/

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

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

statsVariance :: SExp_ "summary :: StatsSummary1D" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/variance/

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

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

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/x_intercept/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/intercept/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/corr-stats/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/covariance/

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

https://docs.timescale.com/api/latest/hyperfunctions/stats_aggs/determination_coeff/

Gapfilling and interpolation

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

https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/time_bucket_gapfill/

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

https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/locf/

interpolate :: SExp_ "values :: any values" -> Maybe (SExp_ "prev :: expression", SExp_ "next :: expression") -> SExp #

https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/interpolate/

Percentile approximation

percentileAgg :: SExp_ "value :: double precision" -> SExp_ "uddsketch" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/percentile_agg/

percentileApproxPercentile :: SExp_ "percentile :: double precision" -> SExp_ "sketch :: uddsketch" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/approx_percentile/

percentileApproxPercentileRank :: SExp_ "percentile :: double precision" -> SExp_ "sketch :: uddsketch" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/approx_percentile_rank/

percentileRollup :: SExp_ "sketch :: uddsketch | digest :: tdigest" -> SExp_ "uddsketch | tdigest" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/rollup-percentile/

percentileMaxVal :: SExp_ "digest :: tdigest" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/max_val/ | https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/min_val/

percentileMinVal :: SExp_ "digest :: tdigest" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/max_val/ | https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/min_val/

percentileMean :: SExp_ "sketch :: uddsketch | digest :: tdigest" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/mean/

percentileError :: SExp_ "sketch :: uddsketch" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/error/

percentileNumVals :: SExp_ "sketch :: uddsketch | digest :: tdigest" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/num_vals-pct/

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

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/percentile-aggregation-methods/uddsketch/

percentileTdigest :: SExp_ "buckets :: integer" -> SExp_ "value :: double precision" -> SExp_ "tdigest" #

https://docs.timescale.com/api/latest/hyperfunctions/percentile-approximation/percentile-aggregation-methods/tdigest/

Counter aggregation

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

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/counter_agg_point/

counterRollup :: SExp_ "cs :: CounterSummary" -> SExp_ "counter_agg :: CounterSummary" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/rollup-counter/

counterCorr :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/corr-stats/

counterCounterZeroTime :: SExp_ "summary :: CounterSummary" -> SExp_ "timestamptz" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/counter_zero_time/

counterDelta :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/delta/

counterExtrapolatedDelta :: SExp_ "summary :: CounterSummary" -> SExp_ "method" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/extrapolated_delta/

counterExtrapolatedRate :: SExp_ "summary :: CounterSummary" -> SExp_ "method" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/extrapolated_rate/

counterIdeltaLeft :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/idelta/

counterIdeltaRight :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/idelta/

counterIntercept :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/intercept-counter/

counterIrateLeft :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/irate/

counterIrateRight :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/irate/

counterNumChanges :: SExp_ "summary :: CounterSummary" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/num_changes/

counterNumElements :: SExp_ "summary :: CounterSummary" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/num_elements/

counterNumResets :: SExp_ "summary :: CounterSummary" -> SExp_ "bigint" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/num_resets/

counterRate :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/rate/

counterSlope :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/slope-counter/

counterTimeDelta :: SExp_ "summary :: CounterSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/time_delta/

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

https://docs.timescale.com/api/latest/hyperfunctions/counter_aggs/with_bounds/

Time weighted averages

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

https://docs.timescale.com/api/latest/hyperfunctions/time-weighted-averages/time_weight/

timeWeightRollup :: SExp_ "TimeWeightSummary" -> SExp_ "TimeWeightSummary" #

https://docs.timescale.com/api/latest/hyperfunctions/time-weighted-averages/rollup-timeweight/

timeWeightAverage :: SExp_ "TimeWeightSummary" -> SExp_ "double precision" #

https://docs.timescale.com/api/latest/hyperfunctions/time-weighted-averages/average-time-weight/

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" #