API Manual

This manual provides instructions on how to use the Gecko API endpoints. All requests are GET requests to https://pi.ubicity.eu/api_project3/apigecko.php. You must include your API key in the X-API-KEY header.

Rate Limits: 1 call per second, monthly limit based on your key.

Authentication: Replace your_api_key with your actual API key in the examples below.

The API endpoint is queried with the table parameter. Additional parameters depend on the table.

Endpoint Structure

• sentiment_index: Latest 7 rows. No additional parameters.
• crypto_signals: Latest 5 rows. No additional parameters.
• OHLCV Tables (ohlcv_data, ohlcv_data_5m, etc.): Requires symbol_id. Optional: start_time (YYYY-MM-DD HH:MM:SS), end_time, limit (default 1000, max 1000).
• advanced_trading_signals: Optional: symbol (e.g., BNBBTC), start_time, end_time, limit (default 1000, max 1000).

Examples

1. OHLCV Data (Example: 1-minute interval)

Fetches OHLCV data for a specific symbol. Replace symbol_id with the actual ID (e.g., 1 for BTCUSDT). Optional parameters shown in example.

Curl (Windows)

curl -H "X-API-KEY: your_api_key" "https://pi.ubicity.eu/api_project3/apigecko.php?table=ohlcv_data&symbol_id=1&start_time=2025-10-01%2000:00:00&end_time=2025-10-07%2023:59:59&limit=500"

Python Script

import requests

url = "https://pi.ubicity.eu/api_project3/apigecko.php"
params = {
    "table": "ohlcv_data",
    "symbol_id": "1",  # Replace with actual symbol_id
    "start_time": "2025-10-01 00:00:00",  # Optional
    "end_time": "2025-10-07 23:59:59",    # Optional
    "limit": "500"                       # Optional, default 1000
}
headers = {"X-API-KEY": "your_api_key"}

response = requests.get(url, params=params, headers=headers)
print(response.json())

Note: Use the same structure for other OHLCV tables like ohlcv_data_5m, ohlcv_data_1h, etc., by changing the table parameter.

2. Sentiment Index

Fetches the latest sentiment index data.

Curl (Windows)

curl -H "X-API-KEY: your_api_key" "https://pi.ubicity.eu/api_project3/apigecko.php?table=sentiment_index"

Python Script

import requests

url = "https://pi.ubicity.eu/api_project3/apigecko.php?table=sentiment_index"
headers = {"X-API-KEY": "your_api_key"}

response = requests.get(url, headers=headers)
print(response.json())

3. Crypto Signals

Fetches the latest crypto signals.

Curl (Windows)

curl -H "X-API-KEY: your_api_key" "https://pi.ubicity.eu/api_project3/apigecko.php?table=crypto_signals"

Python Script

import requests

url = "https://pi.ubicity.eu/api_project3/apigecko.php?table=crypto_signals"
headers = {"X-API-KEY": "your_api_key"}

response = requests.get(url, headers=headers)
print(response.json())

4. Advanced Trading Signals

Fetches advanced trading signals, optionally filtered by symbol and time range.

Curl (Windows)

curl -H "X-API-KEY: your_api_key" "https://pi.ubicity.eu/api_project3/apigecko.php?table=advanced_trading_signals&symbol=BNBBTC&start_time=2025-10-01%2000:00:00&end_time=2025-10-07%2023:59:59&limit=200"

Python Script

import requests

url = "https://pi.ubicity.eu/api_project3/apigecko.php"
params = {
    "table": "advanced_trading_signals",
    "symbol": "BNBBTC",                  # Optional, e.g., BNBBTC
    "start_time": "2025-10-01 00:00:00", # Optional
    "end_time": "2025-10-07 23:59:59",   # Optional
    "limit": "200"                       # Optional, default 1000
}
headers = {"X-API-KEY": "your_api_key"}

response = requests.get(url, params=params, headers=headers)
print(response.json())

Error Handling

Common errors:

• 401 Unauthorized: Invalid or missing API key.
• 429 Too Many Requests: Rate limit exceeded (1/sec or monthly).
• 400 Bad Request: Invalid table or missing required parameters (e.g., symbol_id for OHLCV).

For more details, check the response JSON for error messages.