Skip to main content

Ctrl+K

Getting Started
User Guide
API Reference
Release Notes

English | 中文

Getting Started
User Guide
API Reference
Release Notes

English | 中文

Section Navigation

Basics
- exec
- call
- variable
- sql
- msql
- scalar
- vector
- any_vector
- array_vector
- pair
- matrix
- set
- dictionary
- table
- partial
- swordfish_udf
- meta_code
- connect

Constant
- Base
  - Constant
  - Iterator
- Scalar
  - Scalar
  - FunctionDef
  - Void
  - Bool
  - Char
  - Short
  - Int
  - Long
  - Float
  - Double
  - String
  - Blob
  - Date
  - Month
  - Time
  - Minute
  - Second
  - DateTime
  - Timestamp
  - NanoTime
  - NanoTimestamp
  - DateHour
  - Uuid
  - Int128
  - Ipaddr
  - Duration
  - Handle
  - MetaCode
  - Decimal32
  - Decimal64
  - Decimal128
- Vector
- Pair
  - Pair
- Matrix
  - Matrix
- Set
  - Set
- Dict
- Table
- Enum
  - EnumInt
  - DataType
  - DataForm
  - ObjectType
  - LogLevel
  - ALL
  - FIRST
  - LAST
  - NONE
  - SEQ
  - RANGE
  - VALUE
  - LIST
  - COMPO
  - HASH
  - VOID
  - BOOL
  - CHAR
  - SHORT
  - INT
  - LONG
  - DATE
  - MONTH
  - TIME
  - MINUTE
  - SECOND
  - DATETIME
  - TIMESTAMP
  - NANOTIME
  - NANOTIMESTAMP
  - DATEHOUR
  - FLOAT
  - DOUBLE
  - SYMBOL
  - STRING
  - UUID
  - FUNCTIONDEF
  - HANDLE
  - CODE
  - DATASOURCE
  - RESOURCE
  - ANY
  - DICTIONARY
  - IPADDR
  - INT128
  - BLOB
  - COMPLEX
  - POINT
  - DURATION
  - OBJECT
  - DECIMAL32
  - DECIMAL64
  - DECIMAL128
  - ARRAY
  - SCALAR
  - VECTOR
  - PAIR
  - MATRIX
  - SET
  - DICT
  - TABLE
  - VAR
  - SHARED
  - DEF
  - DEBUG
  - INFO
  - ERROR
  - WARNING

Environment

Streaming

Functions
- Data Types and Conversion
  - array
  - arrayVector
  - bigarray
  - bool
  - blob
  - cast
  - ceil
  - char
  - complex
  - date
  - datehour
  - datetime
  - decimal32
  - decimal64
  - decimal128
  - decimalFormat
  - decimalMultiply
  - deg2rad
  - dict
  - double
  - duration
  - enlist
  - fixedLengthArrayVector
  - floor
  - form
  - format
  - fromJson
  - parseJsonTable
  - hex
  - highDouble
  - highLong
  - int
  - int128
  - ipaddr
  - isOrderedDict
  - long
  - lowDouble
  - lowLong
  - makeKey
  - makeSortedKey
  - matrix
  - minute
  - month
  - nanotime
  - nanotimestamp
  - pair
  - point
  - rad2deg
- Math
  - abs
  - acos
  - acosh
  - add
  - asin
  - asinh
  - atan
  - atanh
  - cbrt
  - cholesky
  - clip
  - clip_
  - cos
  - cosh
  - derivative
  - diag
  - det
  - div
  - eig
  - exp
  - exp2
  - expm1
  - gram
  - gramSchmidt
  - intersection
  - integral
  - inverse
  - iterate
  - log
  - log1p
  - log10
  - log2
  - lu
  - mod
  - mul
  - neg
  - pow
  - qr
  - ratio
  - reciprocal
  - repmat
  - schur
  - signbit
  - signum
  - sin
  - sinh
  - square
  - sqrt
  - sub
  - svd
  - symmetricDifference
  - tan
  - tanh
  - tril
  - triu
- Cumulative Window
  - cumbeta
  - cumcorr
  - cumcount
  - cumcovar
  - cumfirstNot
  - cumlastNot
  - cummax
  - cummed
  - cummin
  - cumnunique
  - cumpercentile
  - cumPositiveStreak
  - cumprod
  - cumrank
  - cumstd
  - cumstdp
  - cumsum
  - cumsum2
  - cumsum3
  - cumsum4
  - cumvar
  - cumvarp
  - cumwavg
  - cumwsum
  - cumavg
  - dynamicGroupCumsum
  - dynamicGroupCumcount
- Moving
  - mLowRange
  - mTopRange
  - mfirst
  - mfirstNot
  - mifirstNot
  - milastNot
  - mlast
  - mlastNot
  - mmax
  - mmaxPositiveStreak
  - mmed
  - mmin
  - mimax
  - mimin
  - mmad
  - mcorr
  - mcount
  - mcovar
  - mpercentile
  - mprod
  - mrank
  - mskew
  - mslr
  - mstd
  - mstdp
  - msum
  - msum2
  - mvar
  - mvarp
  - mwavg
  - mwsum
  - movingTopNIndex
  - movingWindowIndex
  - mbeta
  - mkurtosis
- Time-Based Moving
  - tmLowRange
  - tmTopRange
  - tmfirst
  - tmcount
  - tmcovar
  - tmcorr
  - tmkurtosis
  - tmlast
  - tmmax
  - tmmed
  - tmmin
  - tmpercentile
  - tmprod
  - tmrank
  - tmskew
  - tmstd
  - tmstdp
  - tmsum
  - tmsum2
  - tmvar
  - tmvarp
  - tmwavg
  - tmwsum
  - tmbeta
- mTopN
  - mavgTopN
  - mbetaTopN
  - mcorrTopN
  - mcovarTopN
  - mpercentileTopN
  - msumTopN
  - mstdTopN
  - mstdpTopN
  - mvarTopN
  - mvarpTopN
  - mwsumTopN
- Row-Based
  - rowAlign
  - rowAnd
  - rowAt
  - rowAvg
  - rowBeta
  - rowCorr
  - rowCovar
  - rowCount
  - rowDenseRank
  - rowDot
  - rowEuclidean
  - rowImax
  - rowImin
  - rowKurtosis
  - rowMax
  - rowMin
  - rowMove
  - rowNext
  - rowPrev
  - rowProd
  - rowRank
  - rowSkew
  - rowStd
  - rowStdp
  - rowSum
  - rowSum2
  - rowTanimoto
  - rowVar
  - rowVarp
  - rowWavg
  - rowWsum
  - rowSize
- TA-Lib
  - dema
  - ema
  - gema
  - kama
  - linearTimeTrend
  - ma
  - sma
  - t3
  - tema
  - trima
  - wma
  - wilder
- Time
  - asFreq
  - businessDay
  - businessMonthBegin
  - businessMonthEnd
  - businessQuarterBegin
  - businessQuarterEnd
  - businessYearBegin
  - businessYearEnd
  - concatDateTime
  - date
  - dayOfMonth
  - dayOfWeek
  - dayOfYear
  - daysInMonth
  - convertTZ
  - fy5253
  - fy5253Quarter
  - gmtime
  - hour
  - hourOfDay
  - isLeapYear
  - isMonthEnd
  - isMonthStart
  - isQuarterEnd
  - isQuarterStart
  - isYearEnd
  - isYearStart
  - lastWeekOfMonth
  - microsecond
  - millisecond
  - minuteOfHour
  - month
  - monthBegin
  - monthEnd
  - monthOfYear
  - nanosecond
  - now
  - quarterBegin
  - quarterEnd
  - secondOfMinute
  - semiMonthBegin
  - semiMonthEnd
  - temporalAdd
  - temporalSeq
  - today
  - transFreq
  - weekday
  - weekBegin
  - weekEnd
  - weekOfMonth
  - weekOfYear
  - year
  - yearBegin
  - yearEnd
- Statistics
  - atImax
  - atImin
  - avg
  - contextSum
  - contextSum2
  - count
  - covar
  - covarMatrix
  - crossStat
  - cumnunique
  - demean
  - dot
  - ewmCov
  - ewmMean
  - ewmStd
  - ewmVar
  - gaussianKde
  - gaussianKdePredict
  - histogram2d
  - imax
  - imin
  - kroghInterpolateFit
  - kurtosis
  - linearInterpolateFit
  - mad
  - max
  - maxIgnoreNull
  - med
  - mean
  - min
  - minIgnoreNull
  - mode
  - mmed
  - nunique
  - percentChange
  - percentile
  - percentileRank
  - prod
  - quantile
  - quantileSeries
  - sem
  - skew
  - std
  - stdp
  - summary
  - sum
  - sum2
  - sum3
  - sum4
  - stat
  - var
  - varp
  - wavg
  - wc
  - wcovar
  - wsum
- Correlation
  - acf
  - autocorr
  - corr
  - corrMatrix
  - distance
  - ewmCorr
  - euclidean
  - kendall
  - mutualInfo
  - rowEuclidean
  - rowTanimoto
  - spearmanr
  - tanimoto
- Sequential Analysis
- Interpolation
- Optimization
  - brute
  - brentq
  - fmin
  - fminBFGS
  - fminLBFGSB
  - fminNCG
  - fminSLSQP
  - linprog
  - osqp
  - qclp
  - quadprog
  - scs
  - solve
  - socp
- Operators
  - And
  - Not
  - Or
  - xor
  - bitAnd
  - bitOr
  - bitXor
  - eq
  - ge
  - le
  - gt
  - lt
  - ne
  - In
  - between
  - eqFloat
  - eqObj
  - eqPercent
- Metaprogramming
  - eval
  - sql
  - sqlCol
  - sqlColAlias
  - sqlDelete
  - sqlUpdate
  - expr
  - parseExpr
  - binaryExpr
  - unifiedExpr
  - funcByName
  - makeCall
  - makeUnifiedCall
- Higher-Order Functions
  - accumulate
  - aggrTopN
  - all
  - any
  - byColumn
  - byRow
  - call
  - contextby
  - cross
  - pcross
  - each
  - eachLeft
  - eachPre
  - eachRight
  - eachPost
  - groupby
  - loop
  - ploop
  - moving
  - nullCompare
  - pivot
  - pcall
  - reduce
  - rolling
  - segmentby
  - talib
  - tmoving
  - twindow
  - window
  - withNullFill
  - unifiedCall
  - rowGroupby
- Financial Analysis
  - bondAccrInt
  - bondCashflow
  - bondConvexity
  - bondDirtyPrice
  - cds
  - coint
  - condValueAtRisk
  - cummdd
  - irs
  - maxDrawdown
  - ns
  - nss
  - nssPredict
  - trueRange
  - valueAtRisk
  - vanillaOption
  - varma
- All References
  - abs
  - accumulate
  - acf
  - acos
  - acosh
  - adaBoostClassifier
  - adaBoostRegressor
  - add
  - addColumn
  - addRangePartitions
  - addValuePartitions
  - addVolumes
  - adfuller
  - aggrTopN
  - aj
  - align
  - all
  - And
  - anova
  - any
  - append_
  - appendTuple_
  - array
  - arrayVector
  - asFreq
  - asin
  - asinh
  - asis
  - asof
  - at
  - atImax
  - atImin
  - atan
  - atanh
  - autocorr
  - avg
  - backup
  - backupDB
  - backupSettings
  - backupTable
  - bar
  - base64Decode
  - base64Encode
  - beta
  - between
  - bfill_
  - bigarray
  - binaryExpr
  - binsrch
  - bitAnd
  - bitOr
  - bitXor
  - blob
  - bondAccrInt
  - bondCashflow
  - bondConvexity
  - bondDirtyPrice
  - bondDuration
  - bondYield
  - bool
  - brentq
  - brute
  - bucket
  - bucketCount
  - businessDay
  - businessMonthBegin
  - businessMonthEnd
  - businessQuarterBegin
  - businessQuarterEnd
  - businessYearBegin
  - businessYearEnd
  - byColumn
  - byRow
  - cacheDS_
  - cacheDSNow
  - call
  - cast
  - cbrt
  - cdfBeta
  - cdfBinomial
  - cdfChiSquare
  - cdfExp
  - cdfF
  - cdfGamma
  - cdfKolmogorov
  - cdfLogistic
  - cdfNormal
  - cdfPoisson
  - cdfStudent
  - cdfUniform
  - cdfWeibull
  - cdfZipf
  - cds
  - ceil
  - cell
  - cells
  - char
  - charAt
  - checkBackup
  - chiSquareTest
  - cholesky
  - cj
  - clear_
  - clearAllCache
  - clearAllIOTDBLatestKeyCache
  - clearAllIOTDBStaticTableCache
  - clearAllTSDBSymbolBaseCache
  - clearDSCache_
  - clearDSCacheNow
  - clip
  - clip_
  - coalesce
  - coevent
  - coint
  - col
  - cols
  - columnNames
  - complex
  - compress
  - concat
  - concatDateTime
  - concatMatrix
  - condValueAtRisk
  - conditionalFilter
  - conditionalIterate
  - constantDesc
  - contextCount
  - contextSum
  - contextSum2
  - contextby
  - convertEncode
  - convertExcelFormula
  - convertTZ
  - copy
  - corr
  - corrMatrix
  - cos
  - cosh
  - count
  - countNanInf
  - covar
  - covarMatrix
  - crc32
  - cross
  - crossStat
  - cubicSpline
  - cubicSplinePredict
  - cumPositiveStreak
  - cumavg
  - cumbeta
  - cumcorr
  - cumcount
  - cumcovar
  - cumfirstNot
  - cumlastNot
  - cummax
  - cummdd
  - cummed
  - cummin
  - cumnunique
  - cumpercentile
  - cumprod
  - cumrank
  - cumstd
  - cumstdp
  - cumsum
  - cumsum2
  - cumsum3
  - cumsum4
  - cumvar
  - cumvarp
  - cumwavg
  - cumwsum
  - cut
  - cutPoints
  - dailyAlignedBar
  - date
  - datehour
  - datetime
  - dayOfMonth
  - dayOfWeek
  - dayOfYear
  - daysInMonth
  - decimal128
  - decimal32
  - decimal64
  - decimalFormat
  - decimalMultiply
  - decodeShortGenomeSeq
  - decompress
  - deepCopy
  - defined
  - defs
  - deg2rad
  - deltas
  - dema
  - demean
  - denseRank
  - derivative
  - det
  - diag
  - dict
  - dictUpdate_
  - difference
  - differentialEvolution
  - digitize
  - disableActivePartition
  - disableTSDBAsyncSorting
  - distance
  - distinct
  - div
  - dividedDifference
  - dot
  - double
  - drop
  - dropColumns_
  - dropPartition
  - dropna
  - duration
  - dynamicGroupCumcount
  - dynamicGroupCumsum
  - each
  - eachAt
  - eachLeft
  - eachPost
  - eachPre
  - eachRight
  - eig
  - ej
  - elasticNet
  - elasticNetCV
  - ema
  - enableActivePartition
  - enableTSDBAsyncSorting
  - encodeShortGenomeSeq
  - endsWith
  - enlist
  - eq
  - eqFloat
  - eqObj
  - eqPercent
  - erase_
  - esd
  - euclidean
  - eval
  - ewmCorr
  - ewmCov
  - ewmMean
  - ewmStd
  - ewmVar
  - exists
  - exp
  - exp2
  - expm1
  - expr
  - extractTextSchema
  - eye
  - fTest
  - ffill
  - ffill_
  - fill_
  - find
  - first
  - firstHit
  - firstNot
  - fixedLengthArrayVector
  - fj
  - flatten
  - flip
  - floor
  - flushOLAPCache
  - flushTSDBCache
  - fmin
  - fminBFGS
  - fminLBFGSB
  - fminNCG
  - fminSLSQP
  - form
  - format
  - fromJson
  - fromStdJson
  - fromUTF8
  - funcByName
  - fy5253
  - fy5253Quarter
  - garch
  - gaussianKde
  - gaussianKdePredict
  - gaussianNB
  - ge
  - gema
  - genShortGenomeSeq
  - genericStateIterate
  - genericTStateIterate
  - getBackupList
  - getBackupMeta
  - getBackupStatus
  - getChunkPath
  - getChunksMeta
  - getLevelFileIndexCacheStatus
  - getLicenseExpiration
  - getMemoryStat
  - getOLAPCacheEngineStat
  - getOLAPCachedSymbolBaseMemSize
  - getPKEYCompactionTaskStatus
  - getPKEYMetaData
  - getRecoveryTaskStatus
  - getTSDBCachedSymbolBaseMemSize
  - getTSDBCompactionTaskStatus
  - getTSDBDataStat
  - getTSDBMetaData
  - getTSDBTableIndexCacheStatus
  - getTablet
  - getTabletsMeta
  - glm
  - gmm
  - gmtime
  - gram
  - gramSchmidt
  - groupby
  - groups
  - gt
  - hasNull
  - hashBucket
  - head
  - hex
  - highDouble
  - highLong
  - histogram2d
  - hour
  - hourOfDay
  - ifNull
  - ifValid
  - ifirstHit
  - ifirstNot
  - iif
  - ilastNot
  - ilike
  - imax
  - imaxLast
  - imin
  - iminLast
  - imr
  - In
  - indexedSeries
  - indexedTable
  - initcap
  - int
  - int128
  - integral
  - interpolate
  - intersection
  - interval
  - invBeta
  - invBinomial
  - invChiSquare
  - invExp
  - invF
  - invGamma
  - invLogistic
  - invNormal
  - invPoisson
  - invStudent
  - invUniform
  - invWeibull
  - inverse
  - ipaddr
  - irs
  - isAlNum
  - isAlpha
  - isDigit
  - isDuplicated
  - isIndexedMatrix
  - isIndexedSeries
  - isLeapYear
  - isLower
  - isMonotonic
  - isMonotonicDecreasing
  - isMonotonicIncreasing
  - isMonthEnd
  - isMonthStart
  - isNanInf
  - isNothing
  - isNull
  - isNumeric
  - isOrderedDict
  - isPeak
  - isQuarterEnd
  - isQuarterStart
  - isSorted
  - isSpace
  - isTitle
  - isUpper
  - isValid
  - isValley
  - isVoid
  - isYearEnd
  - isYearStart
  - isort
  - isort_
  - isortTop
  - iterate
  - join
  - join_
  - jsonExtract
  - kama
  - kendall
  - keyedStreamTable
  - keyedTable
  - keys
  - kmeans
  - knn
  - kroghInterpolate
  - kroghInterpolateFit
  - ksTest
  - kurtosis
  - lasso
  - lassoBasic
  - lassoCV
  - last
  - lastNot
  - lastWeekOfMonth
  - latestIndexedTable
  - latestKeyedStreamTable
  - latestKeyedTable
  - le
  - left
  - lfill
  - lfill_
  - license
  - like
  - linearInterpolateFit
  - linearTimeTrend
  - linprog
  - lj
  - loadBackup
  - loadModel
  - loadNpy
  - loadNpz
  - loadRecord
  - loadTable
  - loadText
  - loadTextEx
  - loc
  - localtime
  - loess
  - log
  - log10
  - log1p
  - log2
  - logisticRegression
  - long
  - loop
  - lowDouble
  - lowLong
  - lowRange
  - lower
  - lowerBound
  - lpad
  - lshift
  - lsj
  - lt
  - ltrim
  - lu
  - mLowRange
  - mTopRange
  - ma
  - mad
  - makeCall
  - makeKey
  - makeSortedKey
  - makeUnifiedCall
  - mannWhitneyUTest
  - manova
  - mask
  - matrix
  - mavg
  - mavgTopN
  - max
  - maxDrawdown
  - maxIgnoreNull
  - maxPositiveStreak
  - mbeta
  - mbetaTopN
  - mcorr
  - mcorrTopN
  - mcount
  - mcovar
  - mcovarTopN
  - md5
  - mdd
  - mean
  - med
  - mem
  - member
  - memberModify_
  - merge
  - mfirst
  - mfirstNot
  - microsecond
  - mifirstNot
  - migrate
  - milastNot
  - millisecond
  - mimax
  - mimaxLast
  - mimin
  - miminLast
  - min
  - minIgnoreNull
  - minute
  - minuteOfHour
  - mkurtosis
  - mlast
  - mlastNot
  - mmad
  - mmax
  - mmaxPositiveStreak
  - mmed
  - mmin
  - mmse
  - mod
  - mode
  - month
  - monthBegin
  - monthEnd
  - monthOfYear
  - move
  - moveHotDataToColdVolume
  - moving
  - movingTopNIndex
  - movingWindowIndex
  - mpercentile
  - mpercentileTopN
  - mprod
  - mr
  - mrank
  - mskew
  - mslr
  - mstd
  - mstdTopN
  - mstdp
  - mstdpTopN
  - msum
  - msum2
  - msumTopN
  - mul
  - multiTableRepartitionDS
  - multinomialNB
  - mutualInfo
  - mvar
  - mvarTopN
  - mvarp
  - mvarpTopN
  - mwavg
  - mwsum
  - mwsumTopN
  - nanInfFill
  - nanosecond
  - nanotime
  - nanotimestamp
  - ne
  - neg
  - neville
  - next
  - nextState
  - norm
  - normal
  - Not
  - now
  - ns
  - nss
  - nssPredict
  - nullCompare
  - nullFill
  - nullFill_
  - nullIf
  - nunique
  - objByName
  - objectChecksum
  - objs
  - ols
  - olsEx
  - oneHot
  - Or
  - osqp
  - pack
  - pair
  - panel
  - parseExpr
  - parseInt
  - parseInteger
  - parseJsonTable
  - partial
  - partition
  - pca
  - pcall
  - pcross
  - percentChange
  - percentile
  - percentileRank
  - piecewiseLinFit
  - pivot
  - pj
  - ploadText
  - ploop
  - point
  - poly1d
  - polyFit
  - polyPredict
  - polynomial
  - pop_
  - pow
  - predict
  - prev
  - prevState
  - print
  - prod
  - push_
  - pwj
  - pwlfPredict
  - qclp
  - qr
  - quadprog
  - quantile
  - quantileSeries
  - quarterBegin
  - quarterEnd
  - rad2deg
  - rand
  - randBeta
  - randBinomial
  - randChiSquare
  - randDiscrete
  - randExp
  - randF
  - randGamma
  - randLogistic
  - randMultivariateNormal
  - randNormal
  - randPoisson
  - randStudent
  - randUniform
  - randWeibull
  - randomForestClassifier
  - randomForestRegressor
  - rank
  - ratio
  - ratios
  - rdp
  - reciprocal
  - reduce
  - refCount
  - regexCount
  - regexFind
  - regexFindStr
  - regexReplace
  - regroup
  - remoteRun
  - remoteRunCompatible
  - remoteRunWithCompression
  - removeHead_
  - removeTail_
  - rename_
  - renameTable
  - reorderColumns_
  - repartitionDS
  - repeat
  - replace
  - replace_
  - replaceColumn_
  - replay
  - replayDS
  - repmat
  - resample
  - reshape
  - residual
  - restore
  - restoreDB
  - restoreTable
  - reverse
  - ridge
  - ridgeBasic
  - right
  - rolling
  - rollingPanel
  - round
  - row
  - rowAlign
  - rowAnd
  - rowAt
  - rowAvg
  - rowBeta
  - rowCorr
  - rowCount
  - rowCovar
  - rowDenseRank
  - rowDot
  - rowEuclidean
  - rowGroupby
  - rowImax
  - rowImaxLast
  - rowImin
  - rowIminLast
  - rowKurtosis
  - rowMax
  - rowMin
  - rowMove
  - rowNames
  - rowNext
  - rowNo
  - rowOr
  - rowPrev
  - rowProd
  - rowRank
  - rowSize
  - rowSkew
  - rowStd
  - rowStdp
  - rowSum
  - rowSum2
  - rowTanimoto
  - rowVar
  - rowVarp
  - rowWavg
  - rowWsum
  - rowXor
  - rows
  - rpad
  - rshift
  - rtrim
  - sample
  - saveAsNpy
  - saveDatabase
  - saveDualPartition
  - saveModel
  - savePartition
  - saveTable
  - saveText
  - saveTextFile
  - schema
  - schur
  - scs
  - searchK
  - seasonalEsd
  - second
  - secondOfMinute
  - segment
  - segmentby
  - sej
  - sem
  - semiMonthBegin
  - semiMonthEnd
  - seq
  - sessionWindow
  - set
  - setColumnComment
  - setIndexedMatrix_
  - setIndexedSeries_
  - setRandomSeed
  - setRetentionPolicy
  - shape
  - shapiroTest
  - share
  - short
  - shuffle
  - shuffle_
  - signbit
  - signum
  - sin
  - sinh
  - size
  - skew
  - sleep
  - slice
  - sliceByKey
  - sma
  - snippet
  - socp
  - solve
  - sort
  - sort_
  - sortBy_
  - spearmanr
  - splev
  - spline
  - split
  - splrep
  - sql
  - sqlCol
  - sqlColAlias
  - sqlDS
  - sqlDelete
  - sqlUpdate
  - sqrt
  - square
  - startsWith
  - stat
  - stateIterate
  - std
  - stdp
  - stl
  - strReplace
  - streamTable
  - stretch
  - string
  - stringFormat
  - strip
  - strlen
  - strlenu
  - strpos
  - sub
  - subarray
  - substr
  - substru
  - subtuple
  - sum
  - sum2
  - sum3
  - sum4
  - sumbars
  - summary
  - svd
  - symbol
  - symbolCode
  - symmetricDifference
  - syncDict
  - syntax
  - t3
  - tTest
  - table
  - tableInsert
  - tableUpsert
  - tail
  - take
  - talib
  - talibNull
  - tan
  - tanh
  - tanimoto
  - tema
  - temporalAdd
  - temporalFormat
  - temporalParse
  - temporalSeq
  - tensor
  - textChunkDS
  - til
  - time
  - timestamp
  - tmLowRange
  - tmTopRange
  - tmavg
  - tmbeta
  - tmcorr
  - tmcount
  - tmcovar
  - tmfirst
  - tmkurtosis
  - tmlast
  - tmmax
  - tmmed
  - tmmin
  - tmove
  - tmoving
  - tmpercentile
  - tmprod
  - tmrank
  - tmskew
  - tmstd
  - tmstdp
  - tmsum
  - tmsum2
  - tmvar
  - tmvarp
  - tmwavg
  - tmwsum
  - toCharArray
  - toJson
  - toStdJson
  - toUTF8
  - today
  - topRange
  - transDS_
  - transFreq
  - transpose
  - treasuryConversionFactor
  - triggerTSDBCompaction
  - tril
  - trim
  - trima
  - triu
  - trueRange
  - truncate
  - tupleSum
  - twindow
  - type
  - typestr
  - undef
  - ungroup
  - unifiedCall
  - unifiedExpr
  - union
  - unionAll
  - unpack
  - unpivot
  - update_
  - updateLicense
  - upper
  - upsert_
  - uuid
  - valueAtRisk
  - valueChanged
  - values
  - vanillaOption
  - var
  - varma
  - varp
  - vectorAR
  - vectorNorm
  - version
  - volumeBar
  - wavg
  - wc
  - wcovar
  - weekBegin
  - weekEnd
  - weekOfMonth
  - weekOfYear
  - weekday
  - wilder
  - window
  - winsorize
  - winsorize_
  - withNullFill
  - wj
  - wls
  - wma
  - writeLog
  - writeLogLevel
  - wsum
  - xdb
  - xor
  - year
  - yearBegin
  - yearEnd
  - zTest
  - zigzag
  - zscore

Input/output
- dump
- load
- dumps
- loads

Configs

Plugins
- MatchingEngineSimulator
- Backtest

API Reference
Functions
Math
clip_

clip_#

swordfish.function.clip_()#: Clips X to specified range. The exclamation mark (_) means in-place change in DolphinDB.

previous

clip

next

cos

On this page

clip_()

© Copyright 2025, DolphinDB, Inc..

Created using Sphinx 8.2.0.

Built with the PyData Sphinx Theme 0.16.1.