Probably an easy question on how to query using one user defined operator and regrid.
I started playing around with user defined operators and I was able to write one but got stuck on how can I use ‘regrid’ so that my operator will be called with different subarray as input within the same query.
Taking as an example the trades array from the example queries provided with the latest package, I can call:
"myop( project( between( trades, 10, 1000, null, 10, 9000, null ), price, volume) )"
and successfully get output an array with a single row, and 4 attributes.
in that example myop( ) will take as input the price and volume of all trades between 1000 and 9000 mills for the symbol_id 10
How do I change my query so that myop() will regrid() every 3000 milliseconds?
An example output would look like:
As a side note, a much simpler solution would be to create 4 aggregate functions (e.g. BSA(), BSR(), ASA(), and ASR() )
and then query:
but multiple arguments are not allowed.
Any suggestion how I could go ahead?