Query Examples
Send an Order
- Stock
- Option
- Future
- SRSE
- MLink
REPLACE INTO srtrade.msgstkordergateway (ticker_at, ticker_ts, ticker_tk, accnt, orderSide, groupingCode,
clientFirm, spdrActionType, orderSize, progressRule, marketSession, parentOrderHandling, parentBalanceHandling,
orderLimitType, riskGroupId, traderName, CHECKSUM)
VALUES ('EQT', 'NMS', 'AAPL', 'T.ACCNT', 'Buy', 'XXXX-XXXX-XXXX-XXXX', 'SRTest', 'addReplace', '100',
'AllowImmediate', 'AllDay', 'ActiveTaker', 'PostLimit', 'Market', 'XXXX-XXXX-XXXX-XXXX', 'user.name', 13);
{
"header": {
"mTyp": "SpdrParentOrder",
},
"message": {
"spdrActionType": "AddReplace",
"secKey": {
"at": "EQT",
"ts": "NMS",
"tk": "AAPL"
},
"secType": "Stock",
"accnt": "T.ACCNT",
"clientFirm": "SRTest",
"groupingCode": "XXXX-XXXX-XXXX-XXXX",
"userName": "user.name",
"orderSide": "Buy",
"orderSize": 100,
"marketSession": "AllDay",
"parentOrderHandling": "ActiveTaker",
"parentBalanceHandling": "PostLimit",
"riskGroupId": "XXXX-XXXX-XXXX-XXXX",
}
}
- SRSE
- MLink
REPLACE INTO spiderrock.msgoptordergateway (accnt, clientFirm, marketSession, spdrActionType, oKey_at, okey_ts,
okey_tk, okey_yr, okey_mn, okey_dy, okey_xx, okey_cp, orderSide, orderSize, parentOrderHandling,
parentBalanceHandling, progressRule, orderLimitType, takeLimitClass, makeLimitClass, traderName, groupingCode,
riskGroupId, CHECKSUM)
VALUES ('T.ACCNT', 'SRTest', 'AllDay', 'AddReplace', 'EQT', 'NMS', 'SPX', 2025, 01, 01, 250, 'Call', 'Buy', 10,
'ActiveTaker', 'PostLimit', 'AllowImmediate', 'Market', 'Simple','Simple','user.name', 'XXXX-XXXX-XXXX-XXXX',
'XXXX-XXXX-XXXX-XXXX', 13);
{
"header": {
"mTyp": "SpdrParentOrder",
},
"message": {
"spdrActionType": "AddReplace",
"parentShape": "Single",
"secKey": {
"at": "EQT",
"ts": "NMS",
"tk": "AAPL"
},
"secType": "Option",
"accnt": "T.ACCNT",
"clientFirm": "SRTest",
"groupingCode": "XXXX-XXXX-XXXX-XXXX",
"userName": "user.name",
"orderSide": "Buy",
"orderSize": 10,
"progressRule": "Market",
"marketSession": "AllDay",
"parentOrderHandling": "ActiveTaker",
"parentBalanceHandling": "PostLimit",
"orderLimitType": "Simple",
"riskGroupId": "XXXX-XXXX-XXXX-XXXX",
}
}
- SRSE
- MLink
REPLACE INTO srtrade.msgstkordergateway (accnt, clientFirm, fkey_at, fkey_ts, fkey_tk, fkey_yr, fkey_mn, fkey_dy,
spdrActionType, orderSide, orderSize, publicSize, orderLimitType, parentOrderHandling, parentBalanceHandling,
marketSession, groupingCode, riskGroupId, traderName, orderActiveSize, CHECKSUM)
VALUES ('T.ACCNT', 'SRTEST', 'FUT', 'CME', 'ES', 2025, 01, 01, 'addreplace', 'Buy', 5, 'Randomize', 'Market',
'ActiveTaker', 'PostLimit', 'RegMkt', 'XXXX-XXXX-XXXX-XXXX', 'XXXX-XXXX-XXXX-XXXX', 'user.name', 5, 13);
{
"header": {
"mTyp": "SpdrParentOrder",
},
"message": {
"spdrActionType": "AddReplace",
"parentShape": "Single",
"secKey": {
"at": "FUT",
"ts": "CME",
"tk": "ES"
},
"secType": "Future",
"accnt": "T.ACCNT",
"clientFirm": "SRTest",
"groupingCode": "XXXX-XXXX-XXXX-XXXX",
"userName": "user.name",
"orderSide": "Buy",
"orderSize": 5,
"publicSize": "Randomize",
"marketSession": "RegMkt",
"parentOrderHandling": "ActiveTaker",
"parentBalanceHandling": "PostLimit",
"orderLimitType": "Market",
"riskGroupId": "XXXX-XXXX-XXXX-XXXX",
}
}
Get a Quote
- Stock
- Option
- Future
- SRSE
- MLink
SELECT * FROM srlive.msgstockbookquote WHERE ticker_tk = 'AAPL';
{
"header": {
"mTyp": "MLinkStream"
},
"message": {
"queryLabel": "ExampleStockNbbo",
"activeLatency": 1,
"msgName": "StockBookQuote",
"where":"ticker:eq:AAPL-NMS-EQT"
}
}
- SRSE
- MLink
SELECT * FROM srlive.msgoptionnbboquote WHERE okey_tk = 'AAPL';
{
"header": {
"mTyp": "MLinkStream"
},
"message": {
"queryLabel": "ExampleOptionNbbo",
"activeLatency": 1,
"msgName": "OptionNbboQuote",
}
}
- SRSE
- MLink
SELECT * FROM srlive.msgfuturebookquote WHERE fkey_tk = 'ES';
{
"header": {
"mTyp": "MLinkStream"
},
"message": {
"queryLabel": "ExampleOptionNbbo",
"activeLatency": 1,
"msgName": "FutureBookQuote",
}
}
Insert a Position
- Stock
- Option
- Future
- SRSE
- MLink
INSERT INTO srrisk.msgsodclearingrecordv5 (accnt, secKey_at, secKey_ts, secKey_tk, secType, tradeDate, clientFirm,
daySide, clrPosition, clrMark, TIMESTAMP)
VALUES ('T.ACCNT', 'EQT', 'NMS', 'AAPL', 'Stock', '2025-01-01', 'SRTest', 'StartOfDay', '100', '50', NOW());
{
"header": {
"mTyp": "SodClearingRecordV5"
},
"message": {
"pkey": {
"accnt": "T.ACCNT"
"secKey": {
"at": "EQT",
"ts": "NMS",
"tk": "AAPL",
"dt": "2025-01-01",
},
"secType": "Stock",
"tradeDate": "2025-01-01",
"clientFirm": "SRTest"
},
"daySide": "StartOfDay",
"clrPosition": 100,
"clrMark": 50,
"timestamp": "2025-01-01 12:00:00.000000"
}
}
- SRSE
- MLink
INSERT INTO srrisk.msgsodclearingrecordv5 (accnt, secKey_at, secKey_ts, secKey_tk, secKey_yr, secKey_mn, secKey_dy,
secKey_xx, secKey_cp, secType, tradeDate, clientFirm, daySide, clrPosition, clrMark, TIMESTAMP)
VALUES ('T.ACCNT', 'EQT', 'NMS', 'AAPL', 2025, 01, 01, 250, 'Call', 'Option', '2025-01-01', 'SRTest', 'StartOfDay',
100, 10, NOW());
{
"header": {
"mTyp": "SodClearingRecordV5"
},
"message": {
"pkey": {
"accnt": "T.ACCNT"
"secKey": {
"at": "EQT",
"ts": "NMS",
"tk": "AAPL",
"dt": "2025-01-01",
"xx": "250",
"cp": "Call",
},
"secType": "Option",
"tradeDate": "2025-01-01",
"clientFirm": "SRTest"
},
"daySide": "StartOfDay",
"clrPosition": 100,
"clrMark": 50,
"timestamp": "2025-01-01 12:00:00.000000"
}
}
- SRSE
- MLink
INSERT INTO srrisk.msgsodclearingrecordv5 (accnt, secKey_at, secKey_ts, secKey_tk, secKey_yr, secKey_mn, secKey_dy,
secType, tradeDate, clientFirm, daySide, clrPosition, clrMark, TIMESTAMP)
VALUES ('T.ACCNT', 'FUT', 'CME', 'ES', 2025, 01, 01, 'Future', '2025-01-01', 'SRTest', 'StartOfDay',
100, 10, NOW());
{
"header": {
"mTyp": "SodClearingRecordV5"
},
"message": {
"pkey": {
"accnt": "T.ACCNT"
"secKey": {
"at": "FUT",
"ts": "CME",
"tk": "ES",
"dt": "2025-01-01",
},
"secType": "Future",
"tradeDate": "2025-01-01",
"clientFirm": "SRTest"
},
"daySide": "StartOfDay",
"clrPosition": 100,
"clrMark": 10,
"timestamp": "2025-01-01 12:00:00.000000"
}
}