Pool Historical Daily Data
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.
GET
https://api.cambrian.org/solana/orca/pools/historical-data
Parameters
pool_address* (string)
The public key address of the Orca Whirlpool.
days* (integer)
The number of past days to include in the analysis.
Responses
Code
Description
200
Successful response
Media type: application/vnd.cambrian.table.v1.0.0+json
[
{
"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
}
]
400
Bad Request: Invalid request parameters or malformed request.
401
Unauthorized: Missing or invalid API key. Include X-API-Key header with your request.
403
Forbidden: Invalid API key or insufficient permissions to access this resource.
404
Not Found: Endpoint or resource does not exist.
408
Request Timeout: Request took too long to process. Try again.
500
Internal Server Error: An unexpected error occurred while processing your request.
503
Service Unavailable: The server is temporarily unable to handle the request. Please try again later.
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
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:
JSON
1[
2 {
3 "columns": [
4 {
5 "name": "timestamp",
6 "type": "UInt32"
7 },
8 {
9 "name": "feesUSD",
10 "type": "Nullable(Float64)"
11 },
12 {
13 "name": "volumeUSD",
14 "type": "Nullable(Float64)"
15 },
16 {
17 "name": "feeVolumeRatio",
18 "type": "Nullable(Float64)"
19 },
20 {
21 "name": "updatedAt",
22 "type": "DateTime('UTC')"
23 }
24 ],
25 "data": [
26 [
27 1785283200,
28 20844.159300246247,
29 52110387.08494674,
30 0.0004000000857078176,
31 "2026-08-05T16:03:30+00:00"
32 ],
33 [
34 1785369600,
35 24087.9758500228,
36 60219923.70983283,
37 0.00040000010571401086,
38 "2026-08-05T16:03:30+00:00"
39 ],
40 [
41 1785456000,
42 27193.92486284585,
43 67984794.10235493,
44 0.0004000001062282232,
45 "2026-08-05T16:03:30+00:00"
46 ],
47 [
48 1785542400,
49 10675.020383373696,
50 26687539.511153404,
51 0.00040000017157491543,
52 "2026-08-05T16:03:30+00:00"
53 ],
54 [
55 1785628800,
56 14401.911409827982,
57 36004767.66202655,
58 0.00040000012067894467,
59 "2026-08-05T16:03:30+00:00"
60 ],
61 [
62 1785715200,
63 24215.889979202446,
64 60539706.92858328,
65 0.0004000001190585402,
66 "2026-08-05T16:03:30+00:00"
67 ],
68 [
69 1785801600,
70 28861.18167505007,
71 72152935.9149223,
72 0.00040000010129984397,
73 "2026-08-05T16:03:30+00:00"
74 ],
75 [
76 1785888000,
77 19960.8446639901,
78 49902100.14864973,
79 0.00040000009227127105,
80 "2026-08-05T16:03:30+00:00"
81 ]
82 ],
83 "rows": 8
84 }
85]
2 {
3 "columns": [
4 {
5 "name": "timestamp",
6 "type": "UInt32"
7 },
8 {
9 "name": "feesUSD",
10 "type": "Nullable(Float64)"
11 },
12 {
13 "name": "volumeUSD",
14 "type": "Nullable(Float64)"
15 },
16 {
17 "name": "feeVolumeRatio",
18 "type": "Nullable(Float64)"
19 },
20 {
21 "name": "updatedAt",
22 "type": "DateTime('UTC')"
23 }
24 ],
25 "data": [
26 [
27 1785283200,
28 20844.159300246247,
29 52110387.08494674,
30 0.0004000000857078176,
31 "2026-08-05T16:03:30+00:00"
32 ],
33 [
34 1785369600,
35 24087.9758500228,
36 60219923.70983283,
37 0.00040000010571401086,
38 "2026-08-05T16:03:30+00:00"
39 ],
40 [
41 1785456000,
42 27193.92486284585,
43 67984794.10235493,
44 0.0004000001062282232,
45 "2026-08-05T16:03:30+00:00"
46 ],
47 [
48 1785542400,
49 10675.020383373696,
50 26687539.511153404,
51 0.00040000017157491543,
52 "2026-08-05T16:03:30+00:00"
53 ],
54 [
55 1785628800,
56 14401.911409827982,
57 36004767.66202655,
58 0.00040000012067894467,
59 "2026-08-05T16:03:30+00:00"
60 ],
61 [
62 1785715200,
63 24215.889979202446,
64 60539706.92858328,
65 0.0004000001190585402,
66 "2026-08-05T16:03:30+00:00"
67 ],
68 [
69 1785801600,
70 28861.18167505007,
71 72152935.9149223,
72 0.00040000010129984397,
73 "2026-08-05T16:03:30+00:00"
74 ],
75 [
76 1785888000,
77 19960.8446639901,
78 49902100.14864973,
79 0.00040000009227127105,
80 "2026-08-05T16:03:30+00:00"
81 ]
82 ],
83 "rows": 8
84 }
85]
x402 Payment Option
This endpoint supports pay-per-use access via the x402 payment protocol (v2): pay $0.05 USDC per request using blockchain micropayments. No API key required.
Quickstart (Typescript)
bash
npm install @x402/fetch @x402/evm viem
TypeScript
1import { x402Client } from "@x402/core/client";
2import { ExactEvmScheme } from "@x402/evm/exact/client";
3import { wrapFetchWithPayment } from "@x402/fetch";
4import { privateKeyToAccount } from "viem/accounts";
5const signer = privateKeyToAccount(process.env.EVM_PRIVATE_KEY as `0x${string}`);
6const client = new x402Client();
7client.register("eip155:*", new ExactEvmScheme(signer));
8const fetchWithPayment = wrapFetchWithPayment(fetch, client);
9const response = await fetchWithPayment(
10 "https://x402.cambrian.org/solana/orca/pools/historical-data"
11);
12const data = await response.json();
2import { ExactEvmScheme } from "@x402/evm/exact/client";
3import { wrapFetchWithPayment } from "@x402/fetch";
4import { privateKeyToAccount } from "viem/accounts";
5const signer = privateKeyToAccount(process.env.EVM_PRIVATE_KEY as `0x${string}`);
6const client = new x402Client();
7client.register("eip155:*", new ExactEvmScheme(signer));
8const fetchWithPayment = wrapFetchWithPayment(fetch, client);
9const response = await fetchWithPayment(
10 "https://x402.cambrian.org/solana/orca/pools/historical-data"
11);
12const data = await response.json();
Quickstart (Python)
bash
pip install "x402[httpx]"
Python
1import asyncio, os
2from eth_account import Account
3from x402 import x402Client
4from x402.http.clients import x402HttpxClient
5from x402.mechanisms.evm import EthAccountSigner
6from x402.mechanisms.evm.exact.register import register_exact_evm_client
7async def main():
8 client = x402Client()
9 account = Account.from_key(os.getenv("EVM_PRIVATE_KEY"))
10 register_exact_evm_client(client, EthAccountSigner(account))
11 async with x402HttpxClient(client) as http:
12 response = await http.get("https://x402.cambrian.org/solana/orca/pools/historical-data")
13 print(response.json())
14asyncio.run(main())
2from eth_account import Account
3from x402 import x402Client
4from x402.http.clients import x402HttpxClient
5from x402.mechanisms.evm import EthAccountSigner
6from x402.mechanisms.evm.exact.register import register_exact_evm_client
7async def main():
8 client = x402Client()
9 account = Account.from_key(os.getenv("EVM_PRIVATE_KEY"))
10 register_exact_evm_client(client, EthAccountSigner(account))
11 async with x402HttpxClient(client) as http:
12 response = await http.get("https://x402.cambrian.org/solana/orca/pools/historical-data")
13 print(response.json())
14asyncio.run(main())
Payment Flow
- Send a normal request to the endpoint (no API key needed)
- Server returns 402 Payment Required with payment details
- The x402 SDK automatically signs a payment authorization with your wallet
- The SDK resubmits the request with the signed payment
- 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