Cookbook
Queries that answer a question somebody actually has, with the answer the engine gives.
Every recipe is taken from the guide, where it is explained in full; this page is the index you scan when you know what you want and not how to write it. The answers are rendered on the documentation fixture — real venue codes and symbols, invented numbers.
Positive funding on any venue
Section titled “Positive funding on any venue”Intent: instruments with a positive funding rate on at least one venue.
any(venues where funding > 0){ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": {}, "scopes": { "any(venues where funding > 0)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "funding": { "value": null, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "funding", "venue_ts": null, "received_at": "2026-09-23T11:52:00Z", "age_ms": 485000, "venue_age_ms": null, "valid_until": "2026-09-23T11:57:00Z", "horizon_source": "assumed", "anchor": "receipt", "status": "stale", "reason": "horizon_passed" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "funding": { "value": 0.000013, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "funding", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "funding": { "value": 0.00001, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "funding", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "funding": { "value": 0.000054, "unit": "fraction", "venue": "OKX-PERP", "layer": "funding", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjdlZjMxMGZmYTMyOTI2ZDEifQ" }}Fresh positive funding on at least three venues
Section titled “Fresh positive funding on at least three venues”Intent: the funding rate, normalised to eight hours, is above one basis point on three or more venues, and each of those readings is current. Ask for that with status(funding) = present, not with an age: a settled rate (dYdX, Coinbase INTX) is as old as its settlement — forty minutes into an hourly period it is forty minutes old, and current until the next one is due — so age(funding) < 2m would leave those venues out for most of every hour.
count(venues where funding_8h > 1bps and status(funding) = present) >= 3{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [], "page": { "limit": 1, "returned": 0, "next_cursor": null }}Cross-venue mark dispersion
Section titled “Cross-venue mark dispersion”Intent: the highest and lowest mark price across venues differ by more than five basis points of the lowest, and at least three venues are answering.
(max(venues, mark) - min(venues, mark)) / min(venues, mark) > 5bps and venues_answered >= 3{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "ETH-PERP", "result": "true", "values": { "max(venues, mark)": { "value": 2751, "unit": "quote", "from": [ { "venue": "BYBIT-PERP", "value": 2751, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "status": "present" } ] }, "min(venues, mark)": { "value": 2749, "unit": "quote", "from": [ { "venue": "OKX-PERP", "value": 2749, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "status": "present" } ] }, "venues_answered": { "value": 3, "from": "reference", "as_of": "2026-09-23T12:00:05Z" } }, "scopes": { "max(venues, mark)": { "venues_listed": 3, "venues_in_scope": 3, "excluded": [] }, "min(venues, mark)": { "venues_listed": 3, "venues_in_scope": 3, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "ETHUSDT", "quote": "USDT", "values": { "mark": { "value": 2751, "unit": "quote", "venue": "BYBIT-PERP", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_ETHUSD", "quote": "USD", "values": { "mark": { "value": 2750, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "ETH-USDT-SWAP", "quote": "USDT", "values": { "mark": { "value": 2749, "unit": "quote", "venue": "OKX-PERP", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}Two named venues
Section titled “Two named venues”Intent: the mark price on KRAKEN-FUTURES and BYBIT-PERP differs by more than 10 (quote units).
max(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark) - min(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark) > 10{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "SOL-PERP", "result": "unknown", "values": { "max(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark)": { "value": null, "unit": "quote", "from": [], "reason": "no_value" }, "min(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark)": { "value": null, "unit": "quote", "from": [], "reason": "no_value" } }, "scopes": { "max(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark)": { "venues_listed": 1, "venues_in_scope": 1, "excluded": [] }, "min(venues where venue in (KRAKEN-FUTURES, BYBIT-PERP), mark)": { "venues_listed": 1, "venues_in_scope": 1, "excluded": [] } }, "venues": [ { "venue": "HYPERLIQUID", "symbol": "SOL", "quote": "USDC", "values": { "venue": { "value": "HYPERLIQUID", "venue": "HYPERLIQUID", "layer": "reference", "venue_ts": null, "received_at": "2026-09-23T00:00:00Z", "age_ms": 43205000, "status": "present" }, "mark": { "value": 118, "unit": "quote", "venue": "HYPERLIQUID", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}Tight books wherever there is a book
Section titled “Tight books wherever there is a book”Intent: every venue that publishes an order book has a spread below five basis points. Venues that publish no book (oracle-priced venues) must not make the condition fail.
all(venues where status(bid) = not_published or spread < 5bps){ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": {}, "scopes": { "all(venues where status(bid) = not_published or spread < 0.0005)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "status(bid)": { "value": "present", "venue": "BYBIT-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000011495574, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "status(bid)": { "value": "present", "venue": "HYPERLIQUID", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000022985864, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "status(bid)": { "value": "present", "venue": "KRAKEN-FUTURES", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000022988506, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "status(bid)": { "value": "present", "venue": "OKX-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000002298983, "unit": "fraction", "venue": "OKX-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6ImI5ZTY0YzFjZWJmOTkzZmQifQ" }}Trend on hourly candles, any venue
Section titled “Trend on hourly candles, any venue”Intent: on at least one venue, the 20-candle EMA of hourly closes is above the 50-candle EMA.
any(venues where ema(close, 20) > ema(close, 50)) timeframe 1h{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "1h", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where ema(close, 20) > ema(close, 50))": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "ema(close, 20)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "ema(close, 20)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "ema(close, 20)": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50)": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "ema(close, 20)": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50)": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6ImRkOWI3MzhhMWQzNzY1OTQifQ" }}A cross on the latest closed 15-minute candle, one venue, clean history
Section titled “A cross on the latest closed 15-minute candle, one venue, clean history”Intent: on KRAKEN-FUTURES, the 20-EMA crossed above the 50-EMA on the most recent completed 15-minute candle, and the last 200 candles have no gaps.
any(venues where venue = KRAKEN-FUTURES and crossover(ema(close, 20), ema(close, 50)) and gaps(200) = 0) timeframe 15m{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "15m", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "ETH-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where venue = KRAKEN-FUTURES and crossover(ema(close, 20), ema(close, 50)) and gaps(200) = 0)": { "venues_listed": 3, "venues_in_scope": 3, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "ETHUSDT", "quote": "USDT", "values": { "venue": { "value": "BYBIT-PERP", "venue": "BYBIT-PERP", "layer": "reference", "venue_ts": null, "received_at": "2026-09-23T00:00:00Z", "age_ms": 43205000, "status": "present" }, "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "15m", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "15m", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_ETHUSD", "quote": "USD", "values": { "venue": { "value": "KRAKEN-FUTURES", "venue": "KRAKEN-FUTURES", "layer": "reference", "venue_ts": null, "received_at": "2026-09-23T00:00:00Z", "age_ms": 43205000, "status": "present" }, "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "15m", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "15m", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "ETH-USDT-SWAP", "quote": "USDT", "values": { "venue": { "value": "OKX-PERP", "venue": "OKX-PERP", "layer": "reference", "venue_ts": null, "received_at": "2026-09-23T00:00:00Z", "age_ms": 43205000, "status": "present" }, "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "OKX-PERP", "layer": "candles", "timeframe": "15m", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "OKX-PERP", "layer": "candles", "timeframe": "15m", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}Two timeframes in one condition
Section titled “Two timeframes in one condition”Intent: hourly trend up (EMA 20 above EMA 50 on 1h candles) while the 15-minute RSI is low.
any(venues where ema(close, 20, 1h) > ema(close, 50, 1h) and rsi(close, 14, 15m) < 35){ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where ema(close, 20, 1h) > ema(close, 50, 1h) and rsi(close, 14, 15m) < 35)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "ema(close, 20, 1h)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50, 1h)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "rsi(close, 14, 15m)": { "value": null, "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "15m", "bars": 57, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present", "reason": "gap" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "ema(close, 20, 1h)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50, 1h)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "rsi(close, 14, 15m)": { "value": 88.19612724877551, "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "15m", "bars": 57, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "ema(close, 20, 1h)": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50, 1h)": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "rsi(close, 14, 15m)": { "value": 88.19612724877551, "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "15m", "bars": 57, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "ema(close, 20, 1h)": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 80, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "ema(close, 50, 1h)": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "rsi(close, 14, 15m)": { "value": null, "venue": "OKX-PERP", "layer": "candles", "timeframe": "15m", "bars": 57, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjMxOTVhZGUxMDU2YTFhOWMifQ" }}Which instruments have a venue that has gone quiet
Section titled “Which instruments have a venue that has gone quiet”Intent: instruments where at least one listed venue is not answering (no fresh mark price).
venues_answered < venues_listed{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [], "page": { "limit": 1, "returned": 0, "next_cursor": null }}Stale, missing and not published are three different things
Section titled “Stale, missing and not published are three different things”Intent: instruments where at least one venue’s funding rate is stale — we have a value, but it is older than the freshness bound.
count(venues where status(funding) = stale) >= 1{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": {}, "scopes": { "count(venues where status(funding) = stale)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "status(funding)": { "value": "stale", "venue": "BYBIT-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T11:52:00Z", "age_ms": 485000, "venue_age_ms": null, "valid_until": "2026-09-23T11:57:00Z", "horizon_source": "assumed", "anchor": "receipt", "status": "stale" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "status(funding)": { "value": "present", "venue": "HYPERLIQUID", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "status(funding)": { "value": "present", "venue": "KRAKEN-FUTURES", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "status(funding)": { "value": "present", "venue": "OKX-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}As of a past moment
Section titled “As of a past moment”Intent: which instruments had positive funding on three or more venues at 08:00 UTC today, using only what DEBYKO had received by then.
count(venues where funding > 0) >= 3 as of 2026-09-21T08:00:00Z{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": "2026-09-21T08:00:00Z", "settled": true, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [], "page": { "limit": 1, "returned": 0, "next_cursor": null }}Relaxed freshness for a historical question
Section titled “Relaxed freshness for a historical question”Intent: a week ago at noon, did any venue show open interest at all — accepting values up to ten minutes old.
any(venues where oi > 0) freshness 10m as of 2026-09-14T12:00:00Z{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": "2026-09-14T12:00:00Z", "settled": true, "normalisation_version": "2026-10-12", "freshness": { "ticker": "10m", "mark": "10m", "oi": "10m", "book": "10m", "stats": "10m", "funding": "10m" }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where oi > 0)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "oi": { "value": null, "unit": "base", "venue": "BYBIT-PERP", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "oi": { "value": null, "unit": "base", "venue": "HYPERLIQUID", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "oi": { "value": null, "unit": "base", "venue": "KRAKEN-FUTURES", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "oi": { "value": null, "unit": "base", "venue": "OKX-PERP", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0xNFQxMjowMDowMFoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6Ijg5MDVkMmI1ZmRjNWVhNzEifQ" }}Like-for-like quotes only
Section titled “Like-for-like quotes only”Intent: dispersion of mark prices above ten basis points, comparing only listings quoted in a USD stablecoin or USD.
max(venues where quote in (USDT, USDC, USD), mark) / min(venues where quote in (USDT, USDC, USD), mark) - 1 > 10bps{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [], "page": { "limit": 1, "returned": 0, "next_cursor": null }}Ordering the screen
Section titled “Ordering the screen”Intent: instruments answering on at least two venues, highest eight-hour funding first.
venues_answered >= 2 order by max(venues, funding_8h) desc{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": { "venues_answered": { "value": 4, "from": "reference", "as_of": "2026-09-23T12:00:05Z" }, "max(venues, funding_8h)": { "value": 0.000104, "unit": "fraction", "from": [ { "venue": "HYPERLIQUID", "value": 0.000104, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "status": "present" } ] } }, "scopes": { "max(venues, funding_8h)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "funding_8h": { "value": null, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T11:52:00Z", "age_ms": 485000, "venue_age_ms": null, "valid_until": "2026-09-23T11:57:00Z", "horizon_source": "assumed", "anchor": "receipt", "status": "stale", "reason": "horizon_passed" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "funding_8h": { "value": 0.000104, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "funding_8h": { "value": 0.00008, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "funding_8h": { "value": 0.000054, "unit": "fraction", "venue": "OKX-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjE0MTk1NWNjMGNhMzliODEifQ" }}Alerts, with Agent
Section titled “Alerts, with Agent”Intent: be told when, for any instrument, the 20/50 EMA cross happens on hourly candles on a venue with a clean 200-candle history. The condition is a query like any other:
any(venues where crossover(ema(close, 20), ema(close, 50)) and gaps(200) = 0) timeframe 1h{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "1h", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where crossover(ema(close, 20), ema(close, 50)) and gaps(200) = 0)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "BYBIT-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "HYPERLIQUID", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "KRAKEN-FUTURES", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "crossover(ema(close, 20), ema(close, 50))": { "value": null, "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 201, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" }, "gaps(200)": { "value": null, "venue": "OKX-PERP", "layer": "candles", "timeframe": "1h", "bars": 200, "candle_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6ImViMGQ5ZmE4NmMxMzc3ZWIifQ" }}A rate of change on a snapshot field
Section titled “A rate of change on a snapshot field”Intent: the mark price is more than half a per cent above where it stood five minutes ago, on any venue. mark is a snapshot field, not a candle, and DQL samples it at the effective timeframe.
any(venues where roc(mark, 5) > 0.5%) timeframe 1m{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "1m", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where roc(mark, 5) > 0.005)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "roc(mark, 5)": { "value": null, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "mark", "timeframe": "1m", "bars": 6, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "roc(mark, 5)": { "value": null, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "mark", "timeframe": "1m", "bars": 6, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "roc(mark, 5)": { "value": null, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "mark", "timeframe": "1m", "bars": 6, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "roc(mark, 5)": { "value": null, "unit": "fraction", "venue": "OKX-PERP", "layer": "mark", "timeframe": "1m", "bars": 6, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjRhZDZhYmRjMjY0ZGMzYTEifQ" }}A spread that is unusually wide for this venue
Section titled “A spread that is unusually wide for this venue”Intent: the current spread sits above the 90th percentile of its own last hour — “wide for this venue”, not “wide compared with a number I guessed”.
any(venues where spread > percentile(spread, 60, 90%)) timeframe 1m{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "1m", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where spread > percentile(spread, 60, 0.9))": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "spread": { "value": 0.000011495574, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "percentile(spread, 60, 0.9)": { "value": null, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "book", "timeframe": "1m", "bars": 60, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "spread": { "value": 0.000022985864, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "percentile(spread, 60, 0.9)": { "value": null, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "book", "timeframe": "1m", "bars": 60, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "spread": { "value": 0.000022988506, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "percentile(spread, 60, 0.9)": { "value": null, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "book", "timeframe": "1m", "bars": 60, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "spread": { "value": 0.000002298983, "unit": "fraction", "venue": "OKX-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "percentile(spread, 60, 0.9)": { "value": null, "unit": "fraction", "venue": "OKX-PERP", "layer": "book", "timeframe": "1m", "bars": 60, "sample_end": null, "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjA0NWQ1MGE0MmE4NzI1NjkifQ" }}Real money resting near the mid
Section titled “Real money resting near the mid”Intent: at least one venue has more than two million quote units resting within ten basis points of the mid on the bid side.
any(venues where depth_bid_value(10bps) > 2000000){ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "ETH-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where depth_bid_value(0.001) > 2000000)": { "venues_listed": 3, "venues_in_scope": 3, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "ETHUSDT", "quote": "USDT", "values": { "depth_bid_value(0.001)": { "value": 330108.0, "unit": "quote", "venue": "BYBIT-PERP", "layer": "book", "band": "10bps", "reference": "mid", "levels": 4, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_ETHUSD", "quote": "USD", "values": { "depth_bid_value(0.001)": { "value": 109996.0, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "book", "band": "10bps", "reference": "mid", "levels": 4, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "ETH-USDT-SWAP", "quote": "USDT", "values": { "depth_bid_value(0.001)": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "book", "band": "10bps", "reference": "mid", "levels": null, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}Choosing the columns, and ordering by two keys
Section titled “Choosing the columns, and ordering by two keys”Intent: the instruments where at least two venues answer, the widest funding first and, where that ties, the tighter spread first — and bring back only the three numbers I want.
venues_answered >= 2 select max(venues, funding_8h), min(venues, spread), venues_answered order by max(venues, funding_8h) desc, min(venues, spread) asc{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": { "venues_answered": { "value": 4, "from": "reference", "as_of": "2026-09-23T12:00:05Z" }, "max(venues, funding_8h)": { "value": 0.000104, "unit": "fraction", "from": [ { "venue": "HYPERLIQUID", "value": 0.000104, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "status": "present" } ] }, "min(venues, spread)": { "value": 2.298983e-06, "unit": "fraction", "from": [ { "venue": "OKX-PERP", "value": 0.000002298983, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "status": "present" } ] } }, "scopes": { "max(venues, funding_8h)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] }, "min(venues, spread)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "funding_8h": { "value": null, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T11:52:00Z", "age_ms": 485000, "venue_age_ms": null, "valid_until": "2026-09-23T11:57:00Z", "horizon_source": "assumed", "anchor": "receipt", "status": "stale", "reason": "horizon_passed" }, "spread": { "value": 0.000011495574, "unit": "fraction", "venue": "BYBIT-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "funding_8h": { "value": 0.000104, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000022985864, "unit": "fraction", "venue": "HYPERLIQUID", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "funding_8h": { "value": 0.00008, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000022988506, "unit": "fraction", "venue": "KRAKEN-FUTURES", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "funding_8h": { "value": 0.000054, "unit": "fraction", "venue": "OKX-PERP", "layer": "funding", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:05:04Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "spread": { "value": 0.000002298983, "unit": "fraction", "venue": "OKX-PERP", "layer": "book", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjJhYWQwMDMyMGM4MjFiOTgifQ" }}The venue’s mark candle, not its trade candle
Section titled “The venue’s mark candle, not its trade candle”Intent: compare the last closed hourly mark candle with the live mark price.
any(venues where mark > mark_close) timeframe 1h{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "1h", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where mark > mark_close)": { "venues_listed": 4, "venues_in_scope": 3, "excluded": [ { "venue": "HYPERLIQUID", "symbol": "BTC", "reason": "not_published", "layer": "candles" } ] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "mark": { "value": 86990, "unit": "quote", "venue": "BYBIT-PERP", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "mark_close": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "candles", "price_type": "mark", "timeframe": "1h", "bars": 1, "candle_end": null, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "mark": { "value": 87010, "unit": "quote", "venue": "HYPERLIQUID", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "mark_close": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "candles", "price_type": "mark", "timeframe": "1h", "bars": 1, "candle_end": null, "venue_ts": null, "received_at": null, "age_ms": null, "status": "not_published", "reason": "venue_capability" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "mark": { "value": 87000, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "mark_close": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "price_type": "mark", "timeframe": "1h", "bars": 1, "candle_end": null, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "mark": { "value": 86995, "unit": "quote", "venue": "OKX-PERP", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" }, "mark_close": { "value": null, "unit": "quote", "venue": "OKX-PERP", "layer": "candles", "price_type": "mark", "timeframe": "1h", "bars": 1, "candle_end": null, "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjIwNWFiZDlmN2QwZTQ2YzQifQ" }}Asking for older data on purpose
Section titled “Asking for older data on purpose”Intent: a question about yesterday, where a reading a few minutes old is perfectly good.
any(venues where oi > 1000) freshness 30m as of 2026-09-20T12:00:00Z{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": "2026-09-20T12:00:00Z", "settled": true, "normalisation_version": "2026-10-12", "freshness": { "ticker": "30m", "mark": "30m", "oi": "30m", "book": "30m", "stats": "30m", "funding": "30m" }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where oi > 1000)": { "venues_listed": 4, "venues_in_scope": 4, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "oi": { "value": null, "unit": "base", "venue": "BYBIT-PERP", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "oi": { "value": null, "unit": "base", "venue": "HYPERLIQUID", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "oi": { "value": null, "unit": "base", "venue": "KRAKEN-FUTURES", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "oi": { "value": null, "unit": "base", "venue": "OKX-PERP", "layer": "oi", "venue_ts": null, "received_at": null, "age_ms": null, "status": "missing", "reason": "no_value" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yMFQxMjowMDowMFoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjY0MGUzZjQ5NjgwNDc3MTYifQ" }}One venue’s own symbol
Section titled “One venue’s own symbol”Intent: the listing a venue calls BTCUSDT, whatever DEBYKO calls the instrument.
any(venues where mark > 0) where symbol = "BTCUSDT"{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": {}, "scopes": { "any(venues where mark > 0)": { "venues_listed": 1, "venues_in_scope": 1, "excluded": [] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "mark": { "value": 86990, "unit": "quote", "venue": "BYBIT-PERP", "layer": "mark", "venue_ts": null, "received_at": "2026-09-23T12:00:04Z", "age_ms": 1000, "venue_age_ms": null, "valid_until": "2026-09-23T12:00:34Z", "horizon_source": "assumed", "anchor": "receipt", "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": null }}Who is being forced out
Section titled “Who is being forced out”Intent: at least one venue has had more than a hundred thousand quote units of long positions liquidated in the last hour, and more than twice the value of the short positions liquidated there.
any(venues where liquidation_long_value(4) > 100000 and liquidation_long_value(4) > 2 * liquidation_short_value(4)) timeframe 15m{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "15m", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "true", "values": {}, "scopes": { "any(venues where liquidation_long_value(4) > 100000 and liquidation_long_value(4) > 2 * liquidation_short_value(4))": { "venues_listed": 4, "venues_in_scope": 2, "excluded": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "reason": "off", "layer": "liquidation" }, { "venue": "HYPERLIQUID", "symbol": "BTC", "reason": "not_published", "layer": "liquidation" } ] } }, "venues": [ { "venue": "BYBIT-PERP", "symbol": "BTCUSDT", "quote": "USDT", "values": { "liquidation_long_value(4)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "off", "reason": "policy_off" }, "liquidation_short_value(4)": { "value": null, "unit": "quote", "venue": "BYBIT-PERP", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "off", "reason": "policy_off" } } }, { "venue": "HYPERLIQUID", "symbol": "BTC", "quote": "USDC", "values": { "liquidation_long_value(4)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "not_published", "reason": "venue_capability" }, "liquidation_short_value(4)": { "value": null, "unit": "quote", "venue": "HYPERLIQUID", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "not_published", "reason": "venue_capability" } } }, { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "liquidation_long_value(4)": { "value": 155249.5, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "present" }, "liquidation_short_value(4)": { "value": 26115, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "present" } } }, { "venue": "OKX-PERP", "symbol": "BTC-USDT-SWAP", "quote": "USDT", "values": { "liquidation_long_value(4)": { "value": 1035600, "unit": "quote", "venue": "OKX-PERP", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "present" }, "liquidation_short_value(4)": { "value": 609140, "unit": "quote", "venue": "OKX-PERP", "layer": "liquidation", "timeframe": "15m", "bars": 4, "window_start": "2026-09-23T11:00:00Z", "window_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": null, "age_ms": null, "status": "present" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6IjM5ZjY1Y2QyM2NhYzRjZWYifQ" }}A BTC regime filter
Section titled “A BTC regime filter”Intent: on Kraken, in USD, an instrument whose 9-period average is above its 21-period average, but only while BTC itself is above its own 50-period average — the signal on one pair, the filter on another.
any(venues where venue = KRAKEN-FUTURES and ema(mark_close, 9, 15m) > ema(mark_close, 21, 15m) and ref(BTC-PERP, mark_close) > ref(BTC-PERP, ema(mark_close, 50, 15m))) timeframe 15m where venue = KRAKEN-FUTURES and quote = USD{ "dql": "1", "evaluated_at": "2026-09-23T12:00:05Z", "as_of": null, "settled": false, "timeframe": "15m", "normalisation_version": "2026-10-12", "freshness": { "ticker": null, "mark": null, "oi": null, "book": null, "stats": null, "funding": null }, "instruments": [ { "instrument": "BTC-PERP", "result": "unknown", "values": {}, "scopes": { "any(venues where venue = KRAKEN-FUTURES and ema(mark_close, 9, 15m) > ema(mark_close, 21, 15m) and ref(BTC-PERP, mark_close) > ref(BTC-PERP, ema(mark_close, 50, 15m)))": { "venues_listed": 1, "venues_in_scope": 1, "excluded": [] } }, "venues": [ { "venue": "KRAKEN-FUTURES", "symbol": "PF_XBTUSD", "quote": "USD", "values": { "venue": { "value": "KRAKEN-FUTURES", "venue": "KRAKEN-FUTURES", "layer": "reference", "venue_ts": null, "received_at": "2026-09-23T00:00:00Z", "age_ms": 43205000, "status": "present" }, "ema(mark_close, 9, 15m)": { "value": 85767.62831152731, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "price_type": "mark", "timeframe": "15m", "bars": 36, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present" }, "ema(mark_close, 21, 15m)": { "value": 85547.56873889006, "unit": "quote", "venue": "KRAKEN-FUTURES", "layer": "candles", "price_type": "mark", "timeframe": "15m", "bars": 84, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present" }, "ref(BTC-PERP, mark_close)": { "value": 86995, "unit": "quote", "venue": "KRAKEN-FUTURES", "instrument": "BTC-PERP", "layer": "candles", "price_type": "mark", "timeframe": "15m", "bars": 1, "candle_end": "2026-09-23T12:00:00Z", "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present" }, "ref(BTC-PERP, ema(mark_close, 50, 15m))": { "value": null, "unit": "quote", "venue": "KRAKEN-FUTURES", "instrument": "BTC-PERP", "layer": "candles", "price_type": "mark", "timeframe": "15m", "bars": 200, "candle_end": "2026-09-23T12:00:00Z", "derived": true, "venue_ts": null, "received_at": "2026-09-23T12:00:00.300Z", "age_ms": 4700, "status": "present", "reason": "insufficient_history" } } } ] } ], "page": { "limit": 1, "returned": 1, "next_cursor": "eyJ0IjoiMjAyNi0wOS0yM1QxMjowMDowNVoiLCJhZnRlciI6IkJUQy1QRVJQIiwicSI6ImJkOGNhMzI1Yjg3MjFmZGMifQ" }}Highest and lowest funding across venues over a window
Section titled “Highest and lowest funding across venues over a window”Which venue had the highest (or lowest) BTC funding over the last 6 hours. One call to POST /v2/snapshots/history (the MCP tool history) with summary: true answers it with one short object per listing instead of the series: the max of funding_8h of each listing is the highest rate observed in the window, and its time. funding_8h restates every venue’s rate on the 8 h basis, so the venues compare. The rate is the one observed at the interval’s samples (5m here), the live rate the venue published, not the funding that settled: for what a venue settled, read GET /v2/funding/settlements. Take the largest max over the listings; the smallest min is the lowest. A listing with no reading in the window has n: 0 and a state (gap, off, not_published, missing), never a zero.
{ "where": "base = BTC", "layers": ["funding"], "interval": "5m", "from": "2026-10-27T02:00:00Z", "to": "2026-10-27T08:00:00Z", "summary": true, "fields": ["funding_8h"]}{ "mode": "summary", "interval": "5m", "from": "2026-10-27T02:00:00Z", "to": "2026-10-27T08:00:00Z", "items": [ { "instrument": "BTC-PERP", "venue": "HYPERLIQUID", "venue_symbol": "BTC", "quote": "USDC", "layers": { "funding": { "status": "present", "n": 72, "fields": { "funding_8h": { "min": [0.000081, "2026-10-27T04:35:00Z"], "max": [0.000125, "2026-10-27T07:50:00Z"], "first": [0.0001, "2026-10-27T02:00:00Z"], "last": [0.000121, "2026-10-27T08:00:00Z"] } }, "units": { "funding_8h": "fraction" } } } } ]}