Blockchain structured query

POST/gateway/v1/onchain/query

curl -X POST https://api.orthogonal.com/v1/run \
-H 'Authorization: Bearer orth_live_••••' \
-H 'Content-Type: application/json' \
-d '{
"api": "surf",
"path": "/gateway/v1/onchain/query",
"method": "POST",
"body": {
"limit": ,
"source": ""
}
}'
{
"success": true,
"data": {
"data": [ 1 item ],
"meta": { … },
"$schema": "https://api.asksurf.ai/schemas/DataResponseOnchainRow.json"
}
}
A real response, recorded when Orthogonal checked this endpoint.

$0.02616per call

Every call costs the same.

You aren't charged for failed calls. A wallet payment for a failed call is refunded.

About this endpoint

Blockchain Structured Query: Send a JSON object describing the query. Example: {"source":"agent.ethereum_dex_trades","fields":["block_time"],"filters":[{"field":"block_date","op":"gte","value":"2025-03-01"}],"limit":1}. Use this endpoint when you want structured filtering without writing raw SQL. Discover tables and columns first with GET /v1/onchain/schema. Key rules: - Source format: agent.<table_name> - Max 10,000 rows (default 20), 30s timeout - Always filter on block_date for large tables - Never filter by symbol — it is unindexed (full scan). To resolve a ticker to a contract address, use GET /v1/search/token?q={symbol}&chain={chain} and filter by contract_address instead - For transfer tables, amount is decimal-adjusted display units; amount_raw is the original base-unit value Data refresh: ~24 hours. Example ```json { "source": "agent.ethereum_dex_trades", "fields": ["block_time", "project", "token_pair", "amount_usd", "taker"], "filters": [

Body parameters

Response types

More from Surf API

  1. KOL rankingGET/gateway/v1/smart-money/kol/ranking$0.01308 per callFixed
  2. Liquidation chartGET/gateway/v1/market/liquidation/chart$0.01308 per callFixed
  3. Blockchain SQL queryPOST/gateway/v1/onchain/sql$0.02616 per callFixed
  4. KOL call historyGET/gateway/v1/smart-money/kol/history$0.01308 per callFixed
  5. Order book depthGET/gateway/v1/exchange/depth$0.00654 per callFixed
  6. Latest company financialsGET/gateway/v1/equity/latest-financialsUp to $0.03924 per callResponse-based
  7. Web page fetchGET/gateway/v1/web/fetch$0.00654 per callFixed
  8. Matched market pairsGET/gateway/v1/prediction-market/matching/pairs$0.02616 per callFixed
  9. Polymarket wallet positionsGET/gateway/v1/prediction-market/polymarket/positions$0.02616 per callFixed
  10. Hyperliquid trader leaderboardGET/gateway/v1/hyperliquid/leaderboard$0.02616 per callFixed
  11. Perpetual contract snapshotGET/gateway/v1/exchange/perp$0.00654 per callFixed
  12. KOL activityGET/gateway/v1/smart-money/kol/activity$0.01308 per callFixed
All 145 Surf API endpoints