-
Hi ,
I see you have sorted your trade table in ascending order by time and option_id, but as you can see by the sample data, the trade table isn’t sorted at all.
However, if we look at the nbbo table, you can see it is sorted in ascending order by time.
By sorting tables that do not require it and then preceding to join these tables together is where you can experience an overall table with an incorrect format.
Hope this helps,
Megan