v5.2.2

High Risk Security Update:

• Prevent SQL injection

v5.2.1

High Risk Security Update:

• Prevent SQL injection

v5.2.0

Added:

• clickhouse_response_duration_seconds histogram to /metrics API endpoint

Updated:

• @clickhouse/client library

v5.1.0

Added:

• Historical currency conversion for price data using time-matched exchange rates
• 9 new API endpoints for historical data with currency conversion:
  • GET /v1/metals/history/:symbol/currency/:base - Metal history in currency (raw, last 24h)
  • GET /v1/metals/history/:symbol/currency/:base/hourly - Metal history in currency (hourly, last 90d)
  • GET /v1/metals/history/:symbol/currency/:base/daily - Metal history in currency (daily, all time)
  • GET /v1/crypto/history/:symbol/currency/:base - Crypto history in currency (raw, last 24h)
  • GET /v1/crypto/history/:symbol/currency/:base/hourly - Crypto history in currency (hourly, last 90d)
  • GET /v1/crypto/history/:symbol/currency/:base/daily - Crypto history in currency (daily, all time)
  • GET /v1/stocks/history/:symbol/currency/:base - Stock history in currency (raw, last 24h)
  • GET /v1/stocks/history/:symbol/currency/:base/hourly - Stock history in currency (hourly, last 90d)
  • GET /v1/stocks/history/:symbol/currency/:base/daily - Stock history in currency (daily, all time)

How it works:

1. Fetches asset prices in USD from ClickHouse
2. Retrieves historical exchange rates for the target currency from the same time periods
3. Applies the matching historical conversion rate to each data point
4. Falls back to closest available rate or current rate if no exact match exists

v5.0.0

Added:

• Historical price data storage using ClickHouse
• Aggregation job that runs every 10 minutes to compute hourly and daily aggregates
• 12 new API endpoints for historical data:
  • GET /v1/rates/history/:symbol - Currency history (raw, last 24h)
  • GET /v1/rates/history/:symbol/hourly - Currency history (hourly, last 90d)
  • GET /v1/rates/history/:symbol/daily - Currency history (daily, all time)
  • GET /v1/metals/history/:symbol - Metal history (raw, last 24h)
  • GET /v1/metals/history/:symbol/hourly - Metal history (hourly, last 90d)
  • GET /v1/metals/history/:symbol/daily - Metal history (daily, all time)
  • GET /v1/crypto/history/:symbol - Crypto history (raw, last 24h)
  • GET /v1/crypto/history/:symbol/hourly - Crypto history (hourly, last 90d)
  • GET /v1/crypto/history/:symbol/daily - Crypto history (daily, all time)
  • GET /v1/stocks/history/:symbol - Stock history (raw, last 24h)
  • GET /v1/stocks/history/:symbol/hourly - Stock history (hourly, last 90d)
  • GET /v1/stocks/history/:symbol/daily - Stock history (daily, all time)
• OHLC data (open, high, low, close) for aggregated endpoints
• Cache-friendly endpoints optimized for external proxy caching

Updated:

• Health check endpoint now includes historyEnabled status
• Docker Compose configuration with ClickHouse service
• Environment variables for ClickHouse configuration

v4.1.0

Added:

• OpenMetrics API endpoint for monitoring number of HTTP requests per API endpoint

v4.0.3

Added:

• Support for stocks
• Changed source for metals

Updated:

• Separated metals API endpoint

v3.1.0

Updated:

• Change source for forex and metals

v3.0.1

Added:

• Support for cryptocurrencies

v2.1.0

Added:

• /openapi.json - OpenAPI Specification