SRAuctionState

V8 Message Definiton

METADATA

Attribute	Value
Topic	2510-market-data-auctions
MLink Token	OptExchAuction
Product	SRAuction
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
secKey_at	enum - AssetType	PRI	'None'
secKey_ts	enum - TickerSrc	PRI	'None'
secKey_tk	VARCHAR(12)	PRI	''
secKey_yr	SMALLINT UNSIGNED	PRI	0
secKey_mn	TINYINT UNSIGNED	PRI	0
secKey_dy	TINYINT UNSIGNED	PRI	0
secKey_xx	DOUBLE	PRI	0
secKey_cp	enum - CallPut	PRI	'Call'
secType	enum - SpdrKeyType	PRI	'None'
auctionExch	enum - OptExch	PRI	'None'	exchange handling the auction
auctionExDest	VARCHAR(16)	PRI	''	external exDest of auction usually means auction is offexchange
srAuctionID	BIGINT		0	unique SR AUCTION ID required when responding to an auction notice
exchAuctionId	VARCHAR(20)		''
exchAuctionType	VARCHAR(4)		''
isTestAuction	enum - YesNo		'None'	test auction should only respond from Taccnts
auctionEvent	enum - AuctionEvent		'None'
auctionShape	enum - NoticeShape		'None'
auctionType	enum - AuctionType		'None'
auctionSide	enum - BuySell		'None'	Market side clientimbalance side of auction if known responder should be opposite side
auctionSize	INT		0	size available to trade
auctionPrice	DOUBLE		0	auction price can be positive or negative
isAuctionPriceValid	enum - YesNo		'None'
auctionDuration	INT		0	expected auction imbalance action duration ms
auctionStartSize	INT		0	initial starting auction size
auctionStartPrice	DOUBLE		0	initial starting auction price
auctionStartTimestamp	BIGINT		0	auction start timestamp
minResponseSize	INT		0	minimum size of the response order
limitType	enum - AuctionLimitType		'None'	client imbalance limit type if available
firmType	enum - FirmType		'None'	firm type of the client side of auction if available
memberMPID	VARCHAR(10)		''	exchange member initiating auction if available
clientAccnt	VARCHAR(10)		''	client account designation if known
otherDetail	VARCHAR(16)		''	additional auction detail exchange specific
matchedSize	INT		0	size already matched may still be available to trade at a better price
numUpdates	TINYINT UNSIGNED		0	number of auction updates received not counting auction termination message
numResponses	TINYINT UNSIGNED		0	as reported by exchange if available
bestResponseSize	INT		0
bestResponsePrice	DOUBLE		0
cumFillQuantity	INT		0	as reported by exchange if available
avgFillPrice	DOUBLE		0
marketStatus	enum - MarketStatus		'None'	market status preopen open closed etc
srcTimestamp	BIGINT		0	source timestamp nanoseconds if available
netTimestamp	BIGINT		0	network timestamp message arrival direct exchange gateway
dgwTimestamp	BIGINT		0	network timestamp mbus message send direct exchange gateway
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'
LegsList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
secKey_tk	1
secKey_yr	2
secKey_mn	3
secKey_dy	4
secKey_xx	5
secKey_cp	6
secKey_at	7
secKey_ts	8
secType	9
auctionExch	10
auctionExDest	11

JSON Block (LegsList)

Field	Type	Comment
legSecKey	enum - legSecKey
legSecType	enum - SpdrKeyType
legSide	enum - BuySell
legRatio	enum - legRatio	leg ratio 1 2 etc

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRAuction`.`MsgSRAuctionState`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `secKey_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','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `secKey_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `secKey_tk` = 'Example_secKey_tk'
  AND
    /* Replace with a SMALLINT UNSIGNED */ 
    `secKey_yr` = 123
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `secKey_mn` = 1
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `secKey_dy` = 1
  AND
    /* Replace with a DOUBLE */ 
    `secKey_xx` = 4.56
  AND
    /* Replace with a ENUM('Call','Put','Pair') */ 
    `secKey_cp` = 'Call'
  AND
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */ 
    `secType` = 'None'
  AND
    /* Replace with a ENUM('None','AMEX','BOX','CBOE','ISE','NYSE','PHLX','NSDQ','BATS','C2','NQBX','MIAX','GMNI','CME','CBOT','NYMEX','COMEX','ICE','EDGO','MCRY','MPRL','SDRK','DQTE','EMLD','CFE','MEMX','SPHR','EUREX','CEDX','NXAM','NXBR','NXLS','NXML','NXOS','NXP','ICEFEC','SRC','ICEFEF','TMX') */ 
    `auctionExch` = 'None'
  AND
    /* Replace with a VARCHAR(16) */ 
    `auctionExDest` = 'Example_auctionExDest';

Doc Columns Query

SELECT * FROM SRAuction.doccolumns WHERE TABLE_NAME='SRAuctionState' ORDER BY ordinal_position ASC;