[venu]

Hi Michaela,

Thanks for the quick reply. I just double checked. As per the following console output, the column name “date” of type “d” exist in tradeContext table and seems right.

 

Venu

[venu]

The trade table does not have column called “date”.  I have loaded trade table using the below command.  Please advise if I am missing something.

`:/dbs/2020.08.03/trade`:/dbs/2020.08.03/trade`:/dbs/2020.08.04/trade`:/dbs/2020.08.05/trade`:/dbs/2020.08.06/trade

 

 

I have added date field to tradeContext separately using the following code.

tradeContext:select date:date:2020.08.06+500?1,option_id,trade_id,time ,price,qty,side,edge,exch_id,broker_id,bid,ask from aj[`option_id`time;trade;nbbo]

 

thanks