-
Hi Freddie,
Looks like your nested lj isn’t doing what you expect as only columns from instRef are being joined on, not ones from optRef. The question asks for both.
Hint the table schema of edgeProfileFull should look like
c | t f a ---------| ----- option_id| s numTrds | j avgEdge | f minQty | j maxQty | j inst_id | j opt_type | s strike | j expiry | d inst_syb | s inst_name| C
and the table should be keyed.
Hope this helps!