Skip to content

Instantly share code, notes, and snippets.

#Normal remote keys
#KEY_0
#KEY_1
#KEY_2
#KEY_3
#KEY_4
#KEY_5
#KEY_6
#KEY_7
#KEY_8
CREATE VIEW fix_view AS
SELECT
tag[1] AS Account
, tag[2] AS AdvId
, tag[3] AS AdvRefID
, tag[4] AS AdvSide
, tag[5] AS AdvTransType
, tag[6] AS AvgPx
, tag[7] AS BeginSeqNo
, tag[8] AS BeginString
@yagop
yagop / gist:92d896a58808c2005dda
Created October 26, 2015 11:10 — forked from jeremybeard/gist:d6f36681852787127629
Sample FIX messages using ASCII 001 delimiter
8=FIX.4.19=6135=A34=149=EXEC52=20121105-23:24:0656=BANZAI98=0108=3010=003
8=FIX.4.19=6135=A34=149=BANZAI52=20121105-23:24:0656=EXEC98=0108=3010=003
8=FIX.4.19=4935=034=249=BANZAI52=20121105-23:24:3756=EXEC10=228
8=FIX.4.19=4935=034=249=EXEC52=20121105-23:24:3756=BANZAI10=228
8=FIX.4.19=10335=D34=349=BANZAI52=20121105-23:24:4256=EXEC11=135215788257721=138=1000040=154=155=MSFT59=010=062
8=FIX.4.19=13935=834=349=EXEC52=20121105-23:24:4256=BANZAI6=011=135215788257714=017=120=031=032=037=138=1000039=054=155=MSFT150=2151=010=059
8=FIX.4.19=15335=834=449=EXEC52=20121105-23:24:4256=BANZAI6=12.311=135215788257714=1000017=220=031=12.332=1000037=238=1000039=254=155=MSFT150=2151=010=230
8=FIX.4.19=10335=D34=449=BANZAI52=20121105-23:24:5556=EXEC11=135215789503221=138=1000040=154=155=ORCL59=010=047
8=FIX.4.19=13935=834=549=EXEC52=20121105-23:24:5556=BANZAI6=011=135215789503214=017=320=031=032=037=338