Chain-Scale Screeners with selectWhere
Filter on computed aggregates server-side with selectWhere — the HAVING clause of the Bitquery Trading cube — to build token and wallet screeners in one request.
Argmax Selectors: maximum and minimum
Field(maximum: Key) returns a field's value on the row where Key is maximal — the argmax primitive behind first-value, last-value and peak queries on the Bitquery Trading cube.
Trading Filters and Operators Reference
The complete where-clause surface of the Bitquery Trading cubes: operator sets per scalar type, the any combinator, per-cube filter branches, and the traps that return silently wrong results.
Trading Statistics and Concentration Metrics
Correlation, covariance, quantiles, entropy, Gini and Nakamoto on the Bitquery Trading cube — exact definitions, numerical limits, and which metrics are unsafe on price columns.
Whole-Population Sweeps and Pagination
limitBy returns one row per entity across the entire population, not a top-N. How to page a sweep correctly, and why offset without orderBy silently duplicates rows.
Derived Values with calculate()
calculate(expression:) evaluates an expression server-side on the Bitquery Trading cube — the $ reference rule, when it forces a GROUP BY, and the coercion and non-finite traps.
Wallet Overlap with array_intersect
Find the wallets that traded every token in a set, in one request, using array_intersect on the Bitquery Trading Trades cube.