I am probably at a 'b,' but I believe that if you are comfortable then is time to keep an eye out for new opportunities. I must say I...

SELECT min(upvolume),min(downvolume),Max(upvolume),Max(downvolume)

FROM

(SELECT upvolume,downvolume,TotalTrades from DBVaskVbid WITH (NOLOCK) where CAST(BarStamp AS DATE()) = CAST(GETDATE() AS DATE())) as XDtable

WHERE TotalTrades

BETWEEN

(SELECT MAX(TotalTrades)FROM DBVaskVbid WITH (NOLOCK)) -1000

AND

(SELECT MAX(TotalTrades)FROM...