select askPrice1 *askQty1 , askPrice2*askQty2 ... askPrice50*askQty50 from table. This is already the optimal way.
i've a table with timestamp, symbol, askPrice1,askPrice2, AskQty1,AskQty2 ...
and we will need to output to the following cols,
select askPrice1 *askQty1 , askPrice2*askQty2 ... askPrice50*askQty50 from table
is there any inbuilt functions we can use or any optimal way to calculate on dolphinDB?
thanks!