OptionFlexText

V8 Message Definiton

METADATA

Attribute	Value
Topic	2750-market-data-options
MLink Token	OptFlexPrint
Product	SRLive
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
recordId	CHAR(19)	PRI	'0000-0000-0000-0000'	unique FLEX text key guid
optExch	enum - OptExch		'None'	OPRA participant
text	TINYTEXT		''	complete OPRA FLEX text line
eventType	enum - FlexEventType		'None'	type of event this message represents eg RFQ QTE LST
parseError	TINYTEXT		''	text parse error if any
eventId	CHAR(19)		'0000-0000-0000-0000'	OpraFlexEventeventId this message is associated with if parsed
netTimestamp	BIGINT		0	timestamp of when this message was received
srcTimestamp	BIGINT		0	timestamp from the exchange of when this message was sent

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
recordId	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRLive`.`MsgOptionFlexText` (
    `recordId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'unique FLEX text key (guid)',
    `optExch` 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','ICEFE','SRC') NOT NULL DEFAULT 'None' COMMENT 'OPRA participant',
    `text` TINYTEXT NOT NULL DEFAULT '' COMMENT 'complete OPRA FLEX text line',
    `eventType` ENUM('None','RFQ','QTE','LST','CXL','ADM','IND') NOT NULL DEFAULT 'None' COMMENT 'type of event this message represents, e.g., RFQ, QTE, LST',
    `parseError` TINYTEXT NOT NULL DEFAULT '' COMMENT 'text parse error (if any)',
    `eventId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'OpraFlexEvent.eventId this message is associated with (if parsed)',
    `netTimestamp` BIGINT NOT NULL DEFAULT 0 COMMENT 'timestamp of when this message was received',
    `srcTimestamp` BIGINT NOT NULL DEFAULT 0 COMMENT 'timestamp from the exchange of when this message was sent',
    CONSTRAINT nonnegative_recordId CHECK(ASCII(recordId) < 56),
    CONSTRAINT nonnegative_eventId CHECK(ASCII(eventId) < 56),
    PRIMARY KEY USING HASH (`recordId`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `recordId`,
    `optExch`,
    `text`,
    `eventType`,
    `parseError`,
    `eventId`,
    `netTimestamp`,
    `srcTimestamp`
FROM `SRLive`.`MsgOptionFlexText`
WHERE 
    /* Replace with a CHAR(19) */
    `recordId` = 'Example_recordId';

Doc Columns Query

SELECT * FROM SRLive.doccolumns WHERE TABLE_NAME='OptionFlexText' ORDER BY ordinal_position ASC;