KX Community

Jamie_O__Mahony

To find trades that occurred outside of the best bid offer query the result of the asof join:q)select from aj[`sym`time;t;q] where (priceaskPricetime sym price size bidPrice bidSize askPrice askSize----------------------------------------------------...

Jamie_O__Mahony

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}span.s1 {font-variant-ligatures: no-common-ligatures}operate on the timestamp directly instead of casting it:select avg price by 10*1000000000 xbar time from tAlso note that value is a kdb+ ke...

Jamie_O__Mahony

Most likely you're opening a handle to your current q session:q)\p34067iq)hh:hopen 34067q)hh0iq)hh"2+2"4q)hclose hh'domain [1] hclose hh ^ [0] (.z.pi)

Jamie_O__Mahony

Something like this could be applied before calling .Q.dpft@[`t;cols[t]where "s"=(0!meta t)`t;string]

Jamie_O__Mahony

Correction:p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff}span.s1 {font-variant-ligatures: no-common-ligatures}q)select reverse sums reverse num from tnum---8 8 8 8 7 7 7 4 4 4 On Friday, July 28,...

Jamie_O__Mahony

Hi Birzos,Could you provide an example of the query?Does the following help you out:q)tab:([]a:1 2 3)q)`tab upsert select from tab`tabq)taba-123123Thanks,Jamie

KX Community

User Statistics

User Activity

Re: Trades outside of Quotes.

Re: Get timestamp when using xbar

Re: What does a 0 handle id mean?

Re: auto convert symbol to string before saving to hdb ?

Re: Reverse Sums

Re: Upsert from query