TOKEN_API_POOLS_NO_LIQUIDITY_SORT: pool list has no TVL or volume to sort by

[chillsauce]

/v1/evm/pools?input_token=X&output_token=Y returns candidate pools with no tvl_usd or volume_24h_usd field. Picking the canonical pool requires fanning out OHLC per candidate and ranking manually.

Proposed change. Add tvl_usd and volume_24h_usd to the pool list response. Allow order_by=tvl_usd&limit=N.

[0237h]

Triage: blocked indexer-side, same shape as the other aggregate asks.

Token-native volume_24h per pool is computable today by summing ohlc_prices (interval_min = 60, last 24 hourly buckets) but adds ~760ms p50 to every /v1/evm/pools call — would need a refresh-MV substrate to be efficient as a default field. TVL is not derivable from current MVs at all; no per-pool reserve / balance state is indexed.

USD-denominated versions (tvl_usd, volume_24h_usd) additionally require the price oracle tracked at #521.

Filed indexer-side at pinax-network/substreams-evm#256. Once the per-pool aggregating MV lands, the Token API change is a small JOIN + a few extra response fields.

---

🤖 Generated with Claude Code