Version: Upcoming

LiveSurfaceFixedTerm

LiveSurfaceFixedTerm (surfaceType = 'Live') records contain a live implied volatility term record at standardized days-to-expiration. SurfaceType = 'PriorDay' records contain the final record from the prior trading day.\nThese records include implied and histrical earnings moves, implied earnings date adjustments, and interpolated/gridded atm, sdiv, and quote width values.\nLiveSurfaceTerm records are published to the SpiderRock elastic cluster every 10 minutes for all equity and index underliers with options.

METADATA

Attribute	Value
Topic	1000-analytics
MLink Token	OptSurface
Product	SRAnalytics
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
surfaceType	enum - SurfaceCurveType	PRI	'None'
synSpot	DOUBLE		0	Synthetic spot price marketderived spot when the underlying is not a traded instrument
hEMove	FLOAT		0	expected forward earnings move average of the last 812 underlier earnings moves wmax clipping
hEMoveNum	TINYINT UNSIGNED		0	num historical earnings moves in historical window
hEMoveAvg	FLOAT		0	avg historical earnings move last 812 underlier earnings moves
hEMoveStd	FLOAT		0	std historical earnings move last 812 underlier earnings moves
hEMoveMin	FLOAT		0	max historical earnings move last 812 underlier earnings moves
hEMoveMax	FLOAT		0	min historical earnings move last 812 underlier earnings moves
iEMove	FLOAT		0	implied earnings move implied move all earnings events
iEFitCode	enum - EFitCode		'None'	implied EFit Code
iEFitError	FLOAT		0	eMove fit error term surface fit error
expiryCount	TINYINT UNSIGNED		0	number of actual expirations involved
iEMoveAvg	FLOAT		0	average eMove today
iEMoveStd	FLOAT		0	eMove std dev today
iEMoveMin	FLOAT		0	eMove min today
iEMoveMax	FLOAT		0	emove max today
iEMoveCnt	INT		0	number of surface term fits today
eMoveExpAdj1	INT		0	number of expirations that the next earn date was moved to best fit market term structure if any
eMoveYrsAdj1	FLOAT		0	number of trading years that the next earn date was moved to best fit market term structure if any
eMoveYears1	FLOAT		0	years to expiration from LiveSurfaceCurvepkeyekey eMoveFKey1
eMoveEKey1_at	enum - AssetType		'None'	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveEKey1_ts	enum - TickerSrc		'None'	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveEKey1_tk	VARCHAR(12)		''	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveEKey1_yr	SMALLINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveEKey1_mn	TINYINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveEKey1_dy	TINYINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 1st implied earnings move note this will not match the base earnings calendar if eMoveDtAdj1 0
eMoveExpAdj2	INT		0	number of expirations that the 2nd earn date was moved to best fit market term structure if any
eMoveYrsAdj2	FLOAT		0	number of trading years that the 2nd earn date was moved to best fit market term structure if any
eMoveYears2	FLOAT		0	years to expiration from LiveSurfaceCurvepkeyfkey eMoveFKey2
eMoveEKey2_at	enum - AssetType		'None'	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
eMoveEKey2_ts	enum - TickerSrc		'None'	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
eMoveEKey2_tk	VARCHAR(12)		''	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
eMoveEKey2_yr	SMALLINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
eMoveEKey2_mn	TINYINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
eMoveEKey2_dy	TINYINT UNSIGNED		0	LiveSurfaceCurvepkeyekey immediately after 2nd implied earnings move note this will not match the base earnings calendar if eMoveDtAdj2 0
atmCenI_st	FLOAT		0	short term 5 day model atm volatility censored using iEMult
atmCenI_lt	FLOAT		0	long term 504 day model atm volatility
atmCenI_decay	FLOAT		0	model decay parameter
atmCenI_5d	FLOAT		0	Interpolated 5 day atm vol censored using iEMult
atmCenI_10d	FLOAT		0	Interpolated 10 day atm vol
atmCenI_21d	FLOAT		0	Interpolated 21 day atm vol
atmCenI_42d	FLOAT		0	Interpolated 42 day atm vol
atmCenI_63d	FLOAT		0	Interpolated 63 day atm vol
atmCenI_84d	FLOAT		0	Interpolated 84 day atm vol
atmCenI_105d	FLOAT		0	Interpolated 105 day atm vol
atmCenI_126d	FLOAT		0	Interpolated 126 day atm vol
atmCenI_189d	FLOAT		0	Interpolated 189 day atm vol
atmCenI_252d	FLOAT		0	Interpolated 252 day atm vol
atmCenI_378d	FLOAT		0	Interpolated 378 day atm vol
atmCenI_504d	FLOAT		0	Interpolated 504 day atm vol
atmCenH_st	FLOAT		0	short term 5 day model atm volatility censored using hEMult
atmCenH_lt	FLOAT		0	long term 504 day model atm volatility
atmCenH_decay	FLOAT		0	model decay parameter
atmCenH_5d	FLOAT		0	Interpolated 5 day atm vol censored using hEMult
atmCenH_10d	FLOAT		0	Interpolated 10 day atm vol
atmCenH_21d	FLOAT		0	Interpolated 21 day atm vol
atmCenH_42d	FLOAT		0	Interpolated 42 day atm vol
atmCenH_63d	FLOAT		0	Interpolated 63 day atm vol
atmCenH_84d	FLOAT		0	Interpolated 84 day atm vol
atmCenH_105d	FLOAT		0	Interpolated 105 day atm vol
atmCenH_126d	FLOAT		0	Interpolated 126 day atm vol
atmCenH_189d	FLOAT		0	Interpolated 189 day atm vol
atmCenH_252d	FLOAT		0	Interpolated 252 day atm vol
atmCenH_378d	FLOAT		0	Interpolated 378 day atm vol
atmCenH_504d	FLOAT		0	Interpolated 504 day atm vol
sDiv_5d	FLOAT		0	Interpolated 5 day implied sdiv rate
sDiv_10d	FLOAT		0	Interpolated 10 day implied sdiv rate
sDiv_21d	FLOAT		0	Interpolated 21 day implied sdiv rate
sDiv_42d	FLOAT		0	Interpolated 42 day implied sdiv rate
sDiv_63d	FLOAT		0	Interpolated 63 day implied sdiv rate
sDiv_84d	FLOAT		0	Interpolated 84 day implied sdiv rate
sDiv_105d	FLOAT		0	Interpolated 105 day implied sdiv rate
sDiv_126d	FLOAT		0	Interpolated 126 day implied sdiv rate
sDiv_189d	FLOAT		0	Interpolated 189 day implied sdiv rate
sDiv_252d	FLOAT		0	Interpolated 252 day implied sdiv rate
sDiv_378d	FLOAT		0	Interpolated 378 day implied sdiv rate
sDiv_504d	FLOAT		0	Interpolated 504 day implied sdiv rate
fwdUPrc_5d	FLOAT		0	Interpolated 5 day implied forward price
fwdUPrc_10d	FLOAT		0	Interpolated 10 day implied forward price
fwdUPrc_21d	FLOAT		0	Interpolated 21 day implied forward price
fwdUPrc_42d	FLOAT		0	Interpolated 42 day implied forward price
fwdUPrc_63d	FLOAT		0	Interpolated 63 day implied forward price
fwdUPrc_84d	FLOAT		0	Interpolated 84 day implied forward price
fwdUPrc_105d	FLOAT		0	Interpolated 105 day implied forward price
fwdUPrc_126d	FLOAT		0	Interpolated 126 day implied forward price
fwdUPrc_189d	FLOAT		0	Interpolated 189 day implied forward price
fwdUPrc_252d	FLOAT		0	Interpolated 252 day implied forward price
fwdUPrc_378d	FLOAT		0	Interpolated 378 day implied forward price
fwdUPrc_504d	FLOAT		0	Interpolated 504 day implied forward price
vWidth_5d	FLOAT		0	Interpolated 5 day market vwidth
vWidth_10d	FLOAT		0	Interpolated 10 day market vwidth
vWidth_21d	FLOAT		0	Interpolated 21 day market vwidth
vWidth_42d	FLOAT		0	Interpolated 42 day market vwidth
vWidth_63d	FLOAT		0	Interpolated 63 day market vwidth
vWidth_84d	FLOAT		0	Interpolated 84 day market vwidth
vWidth_105d	FLOAT		0	Interpolated 105 day market vwidth
vWidth_126d	FLOAT		0	Interpolated 126 day market vwidth
vWidth_189d	FLOAT		0	Interpolated 189 day market vwidth
vWidth_252d	FLOAT		0	Interpolated 252 day market vwidth
vWidth_378d	FLOAT		0	Interpolated 378 day market vwidth
vWidth_504d	FLOAT		0	Interpolated 504 day market vwidth
vSlope_5d	FLOAT		0	Interpolated 5 day atm vol slope
vSlope_10d	FLOAT		0	Interpolated 10 day atm vol slope
vSlope_21d	FLOAT		0	Interpolated 21 day atm vol slope
vSlope_42d	FLOAT		0	Interpolated 42 day atm vol slope
vSlope_63d	FLOAT		0	Interpolated 63 day atm vol slope
vSlope_84d	FLOAT		0	Interpolated 84 day atm vol slope
vSlope_105d	FLOAT		0	Interpolated 105 day atm vol slope
vSlope_126d	FLOAT		0	Interpolated 126 day atm vol slope
vSlope_189d	FLOAT		0	Interpolated 189 day atm vol slope
vSlope_252d	FLOAT		0	Interpolated 252 day atm vol slope
vSlope_378d	FLOAT		0	Interpolated 378 day atm vol slope
vSlope_504d	FLOAT		0	Interpolated 504 day atm vol slope
eCnt_5d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_10d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_21d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_42d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_63d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_84d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_105d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_126d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_189d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_252d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_378d	TINYINT UNSIGNED		0	number of expected earnings events
eCnt_504d	TINYINT UNSIGNED		0	number of expected earnings events
status	enum - CurveStatus		'None'
time	TIME(6)		'00:00:00.000000'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	update timestamp

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
surfaceType	4

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRAnalytics`.`MsgLiveSurfaceFixedTerm` (
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '',
    `surfaceType` ENUM('None','Live','PrevDay','Interp','Close','Test') NOT NULL DEFAULT 'None',
    `synSpot` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Synthetic spot price (market-derived spot when the underlying is not a traded instrument)',
    `hEMove` FLOAT NOT NULL DEFAULT 0 COMMENT 'expected forward earnings move (average of the last 8-12 underlier earnings moves; w/max clipping)',
    `hEMoveNum` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'num historical earnings moves in historical window',
    `hEMoveAvg` FLOAT NOT NULL DEFAULT 0 COMMENT 'avg historical earnings move (last 8-12 underlier earnings moves)',
    `hEMoveStd` FLOAT NOT NULL DEFAULT 0 COMMENT 'std historical earnings move (last 8-12 underlier earnings moves)',
    `hEMoveMin` FLOAT NOT NULL DEFAULT 0 COMMENT 'max historical earnings move (last 8-12 underlier earnings moves)',
    `hEMoveMax` FLOAT NOT NULL DEFAULT 0 COMMENT 'min historical earnings move (last 8-12 underlier earnings moves)',
    `iEMove` FLOAT NOT NULL DEFAULT 0 COMMENT 'implied earnings move (implied move; all earnings events)',
    `iEFitCode` ENUM('None','Minimum','CenterError','LeftError','RightError','SplitError','DecentError','LeftBound','RightBound','MaxSteps','CenterFlat') NOT NULL DEFAULT 'None' COMMENT 'implied EFit Code',
    `iEFitError` FLOAT NOT NULL DEFAULT 0 COMMENT 'eMove fit error (term surface fit error)',
    `expiryCount` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of actual expirations involved',
    `iEMoveAvg` FLOAT NOT NULL DEFAULT 0 COMMENT 'average eMove today',
    `iEMoveStd` FLOAT NOT NULL DEFAULT 0 COMMENT 'eMove std dev today',
    `iEMoveMin` FLOAT NOT NULL DEFAULT 0 COMMENT 'eMove min today',
    `iEMoveMax` FLOAT NOT NULL DEFAULT 0 COMMENT 'emove max today',
    `iEMoveCnt` INT NOT NULL DEFAULT 0 COMMENT 'number of surface term fits today',
    `eMoveExpAdj1` INT NOT NULL DEFAULT 0 COMMENT 'number of expirations (+/-) that the next earn date was moved to best fit market term structure (if any)',
    `eMoveYrsAdj1` FLOAT NOT NULL DEFAULT 0 COMMENT 'number of trading years (+/-) that the next earn date was moved to best fit market term structure (if any)',
    `eMoveYears1` FLOAT NOT NULL DEFAULT 0 COMMENT 'years to expiration from LiveSurfaceCurve.pkey.ekey = eMoveFKey1',
    `eMoveEKey1_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveEKey1_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveEKey1_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveEKey1_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveEKey1_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveEKey1_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 1st implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj1 != 0)',
    `eMoveExpAdj2` INT NOT NULL DEFAULT 0 COMMENT 'number of expirations (+/-) that the 2nd earn date was moved to best fit market term structure (if any)',
    `eMoveYrsAdj2` FLOAT NOT NULL DEFAULT 0 COMMENT 'number of trading years (+/-) that the 2nd earn date was moved to best fit market term structure (if any)',
    `eMoveYears2` FLOAT NOT NULL DEFAULT 0 COMMENT 'years to expiration from LiveSurfaceCurve.pkey.fkey = eMoveFKey2',
    `eMoveEKey2_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `eMoveEKey2_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `eMoveEKey2_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `eMoveEKey2_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `eMoveEKey2_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `eMoveEKey2_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'LiveSurfaceCurve.pkey.ekey immediately after 2nd implied earnings move (note: this will not match the base earnings calendar if eMoveDtAdj2 != 0)',
    `atmCenI_st` FLOAT NOT NULL DEFAULT 0 COMMENT 'short term (5 day) model atm volatility (censored using iEMult)',
    `atmCenI_lt` FLOAT NOT NULL DEFAULT 0 COMMENT 'long term (504 day) model atm volatility',
    `atmCenI_decay` FLOAT NOT NULL DEFAULT 0 COMMENT 'model decay parameter',
    `atmCenI_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day atm vol (censored using iEMult)',
    `atmCenI_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day atm vol',
    `atmCenI_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day atm vol',
    `atmCenI_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day atm vol',
    `atmCenI_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day atm vol',
    `atmCenI_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day atm vol',
    `atmCenI_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day atm vol',
    `atmCenI_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day atm vol',
    `atmCenI_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day atm vol',
    `atmCenI_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day atm vol',
    `atmCenI_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day atm vol',
    `atmCenI_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day atm vol',
    `atmCenH_st` FLOAT NOT NULL DEFAULT 0 COMMENT 'short term (5 day) model atm volatility (censored using hEMult)',
    `atmCenH_lt` FLOAT NOT NULL DEFAULT 0 COMMENT 'long term (504 day) model atm volatility',
    `atmCenH_decay` FLOAT NOT NULL DEFAULT 0 COMMENT 'model decay parameter',
    `atmCenH_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day atm vol (censored using hEMult)',
    `atmCenH_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day atm vol',
    `atmCenH_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day atm vol',
    `atmCenH_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day atm vol',
    `atmCenH_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day atm vol',
    `atmCenH_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day atm vol',
    `atmCenH_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day atm vol',
    `atmCenH_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day atm vol',
    `atmCenH_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day atm vol',
    `atmCenH_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day atm vol',
    `atmCenH_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day atm vol',
    `atmCenH_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day atm vol',
    `sDiv_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day implied sdiv rate',
    `sDiv_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day implied sdiv rate',
    `sDiv_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day implied sdiv rate',
    `sDiv_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day implied sdiv rate',
    `sDiv_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day implied sdiv rate',
    `sDiv_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day implied sdiv rate',
    `sDiv_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day implied sdiv rate',
    `sDiv_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day implied sdiv rate',
    `sDiv_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day implied sdiv rate',
    `sDiv_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day implied sdiv rate',
    `sDiv_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day implied sdiv rate',
    `sDiv_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day implied sdiv rate',
    `fwdUPrc_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day implied forward price',
    `fwdUPrc_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day implied forward price',
    `fwdUPrc_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day implied forward price',
    `fwdUPrc_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day implied forward price',
    `fwdUPrc_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day implied forward price',
    `fwdUPrc_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day implied forward price',
    `fwdUPrc_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day implied forward price',
    `fwdUPrc_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day implied forward price',
    `fwdUPrc_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day implied forward price',
    `fwdUPrc_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day implied forward price',
    `fwdUPrc_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day implied forward price',
    `fwdUPrc_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day implied forward price',
    `vWidth_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day market vwidth',
    `vWidth_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day market vwidth',
    `vWidth_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day market vwidth',
    `vWidth_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day market vwidth',
    `vWidth_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day market vwidth',
    `vWidth_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day market vwidth',
    `vWidth_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day market vwidth',
    `vWidth_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day market vwidth',
    `vWidth_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day market vwidth',
    `vWidth_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day market vwidth',
    `vWidth_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day market vwidth',
    `vWidth_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day market vwidth',
    `vSlope_5d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 5 day atm vol slope',
    `vSlope_10d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 10 day atm vol slope',
    `vSlope_21d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 21 day atm vol slope',
    `vSlope_42d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 42 day atm vol slope',
    `vSlope_63d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 63 day atm vol slope',
    `vSlope_84d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 84 day atm vol slope',
    `vSlope_105d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 105 day atm vol slope',
    `vSlope_126d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 126 day atm vol slope',
    `vSlope_189d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 189 day atm vol slope',
    `vSlope_252d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 252 day atm vol slope',
    `vSlope_378d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 378 day atm vol slope',
    `vSlope_504d` FLOAT NOT NULL DEFAULT 0 COMMENT 'Interpolated 504 day atm vol slope',
    `eCnt_5d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_10d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_21d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_42d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_63d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_84d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_105d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_126d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_189d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_252d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_378d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `eCnt_504d` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'number of expected earnings events',
    `status` ENUM('None','Normal','Closed') NOT NULL DEFAULT 'None',
    `time` TIME(6) NOT NULL DEFAULT '00:00:00.000000',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'update timestamp',
    PRIMARY KEY USING HASH (`ticker_tk`,`ticker_at`,`ticker_ts`,`surfaceType`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='LiveSurfaceFixedTerm (surfaceType = \'Live\') records contain a live implied volatility term record at standardized days-to-expiration.  SurfaceType = \'PriorDay\' records contain the final record from the prior trading day.\nThese records include implied and histrical earnings moves, implied earnings date adjustments, and interpolated/gridded atm, sdiv, and quote width values.\nLiveSurfaceTerm records are published to the SpiderRock elastic cluster every 10 minutes for all equity and index underliers with options.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `surfaceType`,
    `synSpot`,
    `hEMove`,
    `hEMoveNum`,
    `hEMoveAvg`,
    `hEMoveStd`,
    `hEMoveMin`,
    `hEMoveMax`,
    `iEMove`,
    `iEFitCode`,
    `iEFitError`,
    `expiryCount`,
    `iEMoveAvg`,
    `iEMoveStd`,
    `iEMoveMin`,
    `iEMoveMax`,
    `iEMoveCnt`,
    `eMoveExpAdj1`,
    `eMoveYrsAdj1`,
    `eMoveYears1`,
    `eMoveEKey1_at`,
    `eMoveEKey1_ts`,
    `eMoveEKey1_tk`,
    `eMoveEKey1_yr`,
    `eMoveEKey1_mn`,
    `eMoveEKey1_dy`,
    `eMoveExpAdj2`,
    `eMoveYrsAdj2`,
    `eMoveYears2`,
    `eMoveEKey2_at`,
    `eMoveEKey2_ts`,
    `eMoveEKey2_tk`,
    `eMoveEKey2_yr`,
    `eMoveEKey2_mn`,
    `eMoveEKey2_dy`,
    `atmCenI_st`,
    `atmCenI_lt`,
    `atmCenI_decay`,
    `atmCenI_5d`,
    `atmCenI_10d`,
    `atmCenI_21d`,
    `atmCenI_42d`,
    `atmCenI_63d`,
    `atmCenI_84d`,
    `atmCenI_105d`,
    `atmCenI_126d`,
    `atmCenI_189d`,
    `atmCenI_252d`,
    `atmCenI_378d`,
    `atmCenI_504d`,
    `atmCenH_st`,
    `atmCenH_lt`,
    `atmCenH_decay`,
    `atmCenH_5d`,
    `atmCenH_10d`,
    `atmCenH_21d`,
    `atmCenH_42d`,
    `atmCenH_63d`,
    `atmCenH_84d`,
    `atmCenH_105d`,
    `atmCenH_126d`,
    `atmCenH_189d`,
    `atmCenH_252d`,
    `atmCenH_378d`,
    `atmCenH_504d`,
    `sDiv_5d`,
    `sDiv_10d`,
    `sDiv_21d`,
    `sDiv_42d`,
    `sDiv_63d`,
    `sDiv_84d`,
    `sDiv_105d`,
    `sDiv_126d`,
    `sDiv_189d`,
    `sDiv_252d`,
    `sDiv_378d`,
    `sDiv_504d`,
    `fwdUPrc_5d`,
    `fwdUPrc_10d`,
    `fwdUPrc_21d`,
    `fwdUPrc_42d`,
    `fwdUPrc_63d`,
    `fwdUPrc_84d`,
    `fwdUPrc_105d`,
    `fwdUPrc_126d`,
    `fwdUPrc_189d`,
    `fwdUPrc_252d`,
    `fwdUPrc_378d`,
    `fwdUPrc_504d`,
    `vWidth_5d`,
    `vWidth_10d`,
    `vWidth_21d`,
    `vWidth_42d`,
    `vWidth_63d`,
    `vWidth_84d`,
    `vWidth_105d`,
    `vWidth_126d`,
    `vWidth_189d`,
    `vWidth_252d`,
    `vWidth_378d`,
    `vWidth_504d`,
    `vSlope_5d`,
    `vSlope_10d`,
    `vSlope_21d`,
    `vSlope_42d`,
    `vSlope_63d`,
    `vSlope_84d`,
    `vSlope_105d`,
    `vSlope_126d`,
    `vSlope_189d`,
    `vSlope_252d`,
    `vSlope_378d`,
    `vSlope_504d`,
    `eCnt_5d`,
    `eCnt_10d`,
    `eCnt_21d`,
    `eCnt_42d`,
    `eCnt_63d`,
    `eCnt_84d`,
    `eCnt_105d`,
    `eCnt_126d`,
    `eCnt_189d`,
    `eCnt_252d`,
    `eCnt_378d`,
    `eCnt_504d`,
    `status`,
    `time`,
    `timestamp`
FROM `SRAnalytics`.`MsgLiveSurfaceFixedTerm`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a ENUM('None','Live','PrevDay','Interp','Close','Test') */ 
    `surfaceType` = 'None';

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='LiveSurfaceFixedTerm' ORDER BY ordinal_position ASC;

METADATA​

Table Definition​

PRIMARY KEY DEFINITION (Unique)​

CREATE TABLE EXAMPLE QUERY​

SELECT TABLE EXAMPLE QUERY​

Doc Columns Query​