Pool Historical Daily Data

Overview

Retrieves historical daily fee and volume data (in USD) for a specific Orca Whirlpool over a specified timeframe. Each row represents a single day and includes total fees, trading volume, and the fee-to-volume ratio, which supports trend analysis of pool activity over time.

Business Value

• Pool Performance Analysis: Track fee generation and trading volume trends over time to assess pool profitability
• Liquidity Strategy Optimization: Analyze historical data to optimize liquidity provision timing and amounts
• Investment Decision Making: Use historical volume and fee data to inform decisions about which pools to participate in
• Risk Management: Monitor pool activity patterns to identify potential risks or opportunities
• Portfolio Tracking: Track the historical performance of pools in your liquidity portfolio

Endpoint Details

URL:

https://api.cambrian.org/solana/orca/pools/historical-data

Method: GET
Authentication: Required via X-API-Key header

Query Parameters

Response Field Descriptions

Examples

1. Retrieve 7-Day Historical Data for a Pool

This example fetches the past 7 days of fee and volume history for a specific Orca Whirlpool, useful for a quick weekly performance snapshot.

curl -X GET "https://api.cambrian.org/solana/orca/pools/historical-data?pool_address=Czfq3xZZDmsdGdUyrNLtRhGc47cXcZtLG4crryfu44zE&days=7" \
  -H "X-API-Key: YOUR_API_KEY" \
  -H "Content-Type: application/json"

Response:

[
  {
    "columns": [
      {
        "name": "timestamp",
        "type": "UInt32"
      },
      {
        "name": "feesUSD",
        "type": "Nullable(Float64)"
      },
      {
        "name": "volumeUSD",
        "type": "Nullable(Float64)"
      },
      {
        "name": "feeVolumeRatio",
        "type": "Nullable(Float64)"
      },
      {
        "name": "updatedAt",
        "type": "DateTime('UTC')"
      }
    ],
    "data": [
      [
        1785283200,
        20844.159300246247,
        52110387.08494674,
        0.0004000000857078176,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785369600,
        24087.9758500228,
        60219923.70983283,
        0.00040000010571401086,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785456000,
        27193.92486284585,
        67984794.10235493,
        0.0004000001062282232,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785542400,
        10675.020383373696,
        26687539.511153404,
        0.00040000017157491543,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785628800,
        14401.911409827982,
        36004767.66202655,
        0.00040000012067894467,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785715200,
        24215.889979202446,
        60539706.92858328,
        0.0004000001190585402,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785801600,
        28861.18167505007,
        72152935.9149223,
        0.00040000010129984397,
        "2026-08-05T16:03:30+00:00"
      ],
      [
        1785888000,
        19960.8446639901,
        49902100.14864973,
        0.00040000009227127105,
        "2026-08-05T16:03:30+00:00"
      ]
    ],
    "rows": 8
  }
]

Note: result collections are limited to 10 items. The response returns 8 daily rows for the requested Orca Whirlpool, each with fees, volume, and the resulting fee-to-volume ratio. The fee rate stays consistent at about 0.04% across days even as volume varies.

x402 Payment Option

This endpoint supports pay-per-use access via the x402 payment protocol (v2), letting you pay $0.05 USDC per request using blockchain micropayments. No API key required.

Quick Start (TypeScript)

npm install @x402/fetch @x402/evm viem

import { x402Client } from "@x402/core/client";
import { ExactEvmScheme } from "@x402/evm/exact/client";
import { wrapFetchWithPayment } from "@x402/fetch";
import { privateKeyToAccount } from "viem/accounts";

const signer = privateKeyToAccount(process.env.EVM_PRIVATE_KEY as `0x${string}`);
const client = new x402Client();
client.register("eip155:*", new ExactEvmScheme(signer));

const fetchWithPayment = wrapFetchWithPayment(fetch, client);
const response = await fetchWithPayment(
  "https://x402.cambrian.org/solana/orca/pools/historical-data"
);
const data = await response.json();

Quick Start (Python)

pip install "x402[httpx]"

import asyncio, os
from eth_account import Account
from x402 import x402Client
from x402.http.clients import x402HttpxClient
from x402.mechanisms.evm import EthAccountSigner
from x402.mechanisms.evm.exact.register import register_exact_evm_client

async def main():
    client = x402Client()
    account = Account.from_key(os.getenv("EVM_PRIVATE_KEY"))
    register_exact_evm_client(client, EthAccountSigner(account))

    async with x402HttpxClient(client) as http:
        response = await http.get("https://x402.cambrian.org/solana/orca/pools/historical-data")
        print(response.json())

asyncio.run(main())

Payment Flow

1. Send a normal request to the endpoint (no API key needed)
2. Server returns 402 Payment Required with payment details
3. The x402 SDK automatically signs a payment authorization with your wallet
4. The SDK resubmits the request with the signed payment
5. Server verifies payment and returns the API response

The x402 SDK handles steps 2 through 5 automatically.

Network: Base (chain ID 8453) | Currency: USDC | Price: $0.05 per request