Shown: the median perpetual’s book depth across the top 25 levels, as a share of its 20:00–20:45 average, per venue, 18:00–01:00 UTC on 10 Oct 2025; minutes under half of normal take the strong tone, and the lowest of all, OKX’s 8.5% at 22:06, is orange · built with l2_liquidity 1m
Execution cost is not constant through the day. Spreads widen, depth thins, and order flow turns adverse together around stressed periods. For a moderate-frequency order, when you execute can matter more than shaving microseconds off the route. This notebook measures when liquidity is deep, spreads are narrow, and flow is least toxic, then ranks the hours by modelled execution cost and cross-checks that ranking against measured slippage.
Or have your agent rerun this notebook and tell you what it finds. Start in ClaudeClaude CodeCodexSee the prompt
01
02
03
Metrics in this use case
Know when liquidity is deep, when spreads are wide, and when flow turns toxic.
Or get a free API key to run the notebooks on every metric for Q3 2026 on BTC, ETH, SOL and 10 RWA perps.
Shown: minute lows of the 465 Binance perpetuals, 20:40–22:00 UTC on 10 Oct 2025, with BTC’s path traced · built with ohlcv 1m
Indices
Whether positions are building or unwinding beyond what price explains, how large open interest is against daily trading, and the funding paid on new positions.
Need the ticks behind this metric? Prime + Raw includes raw mark price, funding rate, trades.
Shown: open_interest_divergence, hourly, 1–31 January 2024, from this page's Sample CSV · extreme: −7.861, 3 Jan, 12:00 UTC · built with positioning
/api/v1/data/positioning| Field | Name | Description |
|---|---|---|
open_interest_divergence | Open Interest Divergence | The open interest build (log open interest in contracts minus its 12-hour time-decayed mean, in units of that gap's 7-day root mean square, both over the bars before) left after removing what the same build on mark price explains (a 7-day time-decayed beta, both clipped at ±3), in units of its own 7-day root mean square. Positions building (above 0) or unwinding (below 0) beyond what price explains; uncorrelated with price |
leverage_index | Leverage Index | Open interest notional divided by the 7-day time-decayed mean of daily taker notional, over the days before the bar's day. Open interest per dollar a day trades |
crowding | Crowding | 1e4 × 1-day time-decayed funding rate × max(0, 100 × (log open interest − its 3.5-day time-decayed mean)). Funding, in bps per venue funding period, paid on positions being added; 0 while positions shrink |
# Install the Aperiodic CLI into ~/.local/bin
mkdir -p "$HOME/.local/bin"
curl -fsSL https://raw.githubusercontent.com/aperiodic-io/cli/main/install.sh | INSTALL_DIR="$HOME/.local/bin" bash
export PATH="$HOME/.local/bin:$PATH"
# Free preview — no API key required
aperiodic positioning --preview \
--exchange binance-futures \
--symbol perpetual-BTC-USDT:USDT \
--interval 5m \
--timestamp exchange \
--start-date 2025-05-01 \
--end-date 2025-05-31 \
--output-dir ./data && echo "Saved to $PWD/data"Every new row as it is computed, over WebSocket at wss://stream.aperiodic.io/v1/stream. Authenticate with your API key in the X-API-KEY header and subscribe to channels named positioning.<exchange>.<interval>, on intervals 15m, 30m, 1h, 4h, 1d. Streaming is included on Live plans.
pip install "aperiodic[stream]"import os
from aperiodic import stream
for message in stream(
api_key=os.environ["APERIODIC_API_KEY"],
dataset="positioning",
exchange="binance-futures",
interval="15m",
symbols=["perpetual-BTC-USDT:USDT"], # omit for every symbol on your plan
):
print(message.channel, message.snapshot, message.data)timestampreqstringTimestamp source. 'exchange' uses the exchange-reported timestamp, 'true' uses actual arrival time at our servers.
exchangetrueintervalreqstringAggregation time interval for the data.
15m30m1h4h1dexchangereqstringSource exchange for the data.
binance-futuresokx-perpshyperliquid-perpssymbolreqstringTrading pair symbol in the format of Atlas' universal symbology: https://github.com/aperiodic-io/atlas. Crypto and real-world asset (RWA) perpetuals share it: `perpetual-BTC-USDT:USDT`, `perpetual-TSLA-USDT:USDT` for a tokenized stock on Binance or OKX, and `perpetual-XYZ:TSLA-USDC:USDC` for a Hyperliquid HIP-3 market, its dex before the colon. /metadata/symbols lists a venue's symbols with their asset classes.
start_datereqstring<date>Start date for the data range (YYYY-MM-DD format). A metric series starts on the first day of the raw series it is computed from (see /metadata/raw); raw trades and quotes start binance-futures from 2020-01-01, okx-perps from 2019-09-01, hyperliquid-perps from 2025-01-01. Earlier days return no files. How far back you can go depends on the plan: 5 years on Pro, full history on Prime, Prime + Raw and Institutional. An earlier start_date than the plan reaches returns 403.
end_datereqstring<date>End date for the data range (YYYY-MM-DD format). Must be greater than or equal to start_date.
Successful response with download URLs for every existing file covering the range from the series' published start — one per month before 2026-08-01, one per day from 2026-08-01 onwards
filesobject[]requiredFiles covering the requested date range, in chronological order. Data before 2026-08-01 is split by month (one file per calendar month, no `day`); data from 2026-08-01 onwards is split by day (one file per calendar day, with `day` set). The changeover falls on a month boundary, so a given month is served entirely one way or the other; a range spanning it returns the earlier months as monthly files followed by a daily file per day.
yearintegerrequiredYear of the data file
monthintegerrequiredMonth of the data file (1-12)
dayintegerDay of the data file (1-31). Present only on daily files, i.e. those covering 2026-08-01 onwards. Absent on monthly files, which cover an entire calendar month.
urlstring<uri>requiredPresigned URL for direct file download (valid for 5 minutes). URLs are served from dataset-specific subdomains, e.g. ohlcv.aperiodic.io, trade-metrics.aperiodic.io, l1-metrics.aperiodic.io, l2-metrics.aperiodic.io, derivative-metrics.aperiodic.io.
{
"files": [
{
"year": 2026,
"month": 6,
"url": "https://ohlcv.aperiodic.io/binance-futures/1h/BTCUSDT/2026-06.parquet?X-Amz-Expires=300&..."
},
{
"year": 2026,
"month": 7,
"url": "https://ohlcv.aperiodic.io/binance-futures/1h/BTCUSDT/2026-07.parquet?X-Amz-Expires=300&..."
},
{
"year": 2026,
"month": 8,
"day": 1,
"url": "https://ohlcv.aperiodic.io/binance-futures/1h/BTCUSDT/2026-08-01.parquet?X-Amz-Expires=300&..."
},
{
"year": 2026,
"month": 8,
"day": 2,
"url": "https://ohlcv.aperiodic.io/binance-futures/1h/BTCUSDT/2026-08-02.parquet?X-Amz-Expires=300&..."
}
]
}
Prefilled with the shared DEMO-KEY and a free preview slice — send the request to see live data, no account required.
/api/v1/data/preview/positioning?timestamp=exchange&interval=5m&exchange=binance-futures&symbol=perpetual-BTC-USDT%3AUSDT&start_date=2025-05-01&end_date=2025-05-31