Skip to main content
Back to top
Ctrl
+
K
Getting Started
User Guide
API Reference
Release Notes
Search
Ctrl
+
K
English
|
中文
Choose version
Search
Ctrl
+
K
Getting Started
User Guide
API Reference
Release Notes
English
|
中文
Choose version
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
Vector
AnyVector
ArrayVector
Pair
Pair
Matrix
Matrix
Set
Set
Dict
Dictionary
DictionaryItems
DictionaryItemsIterator
Table
Table
StreamTable
StreamEngine
StreamBroadcastEngine
TimeSeriesEngine
CrossSectionalEngine
ReactiveStateEngine
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
DefaultConnection
Connection
DefaultSessionConnection
OLTPConnection
OLTPConnection
CatalogConnection
CatalogConnection
Schema
Partition
StorageType
list_catalogs
exists_catalog
create_catalog
drop_catalog
Contexts
EmptyContext
MetaCodeContext
Streaming
Subscription
StreamTable
SubscriptionHelper
Topic
StreamTableInfo
PersistenceMetaInfo
table
topic
exists_topic
list_shared_tables
list_unloaded_persisted_tables
exists
drop
StreamEngine
StreamEngine
EngineStat
EngineType
Builder
list
get
drop
StreamBroadcastEngine
StreamBroadcastEngine
StreamBroadcastEngineStat
StreamBroadcastEngineBuilder
StreamFilterEngineBuilder
StreamFilterEngine
StreamFilterEngineStat
StreamFilterEngineBuilder
TimeSeriesEngine
TimeSeriesEngine
TimeSeriesEngineStat
TimeSeriesEngineBuilder
CrossSectionalEngine
CrossSectionalEngine
CrossSectionalEngineStat
CrossSectionalEngineBuilder
ReactiveStateEngine
ReactiveStateEngine
ReactiveStateEngineStat
ReactiveStateEngineBuilder
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
isMonotonicIncreasing
isMonotonic
isMonotonicDecreasing
isPeak
isValley
zigzag
Interpolation
cubicSpline
cubicSplinePredict
dividedDifference
kroghInterpolate
loess
neville
spline
splrep
splev
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
Config
ConfigDescriptor
StaticConfigDescriptor
Plugins
MatchingEngineSimulator
MatchingEngineSimulator
MatchingEngineSimulatorStat
Exchange
MarketDataType
MatchingEngineSimulatorConfig
Backtest
AssetType
MarketType
MarketDataType
MatchingMode
AccountType
Account
BacktestBasicConfig
StockConfig
MarginConfig
OptionConfig
FuturesConfig
BondConfig
CryptoConfig
StrategyTemplate
StrategyInterface
Backtester
TraditionalBacktester
StockOrderMixin
FuturesOrderMixin
OptionOrderMixin
MarginOrderMixin
BondOrderMixin
CryptoOrderMixin
AlgoOrderMixin
trigger_time
translator
API Reference
Constant
Enum
TIME
TIME
#
swordfish._enums.
TIME
=
DataType(TIME,
val=8)
#
On this page
TIME