Home › Forums › KX Academy › Capstone Project Issue | 3. Data Analytics and Reporting › Re: Capstone Project Issue | 3. Data Analytics and Reporting
-
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