InfluxDB Monitoring Setup for Trading System
Budget: $30 – $250 SGD
I am developing an algorithmic trading system that involves real-time data ingestion, storage, and monitoring. I need a freelancer to set up InfluxDB as a time-series database and configure an InfluxDB → Prometheus exporter for monitoring market and trading data.
This system will store and analyze market data, trading signals, and execution metrics, with real-time dashboards in Grafana.
Scope of Work
1. InfluxDB Setup
• Install and configure InfluxDB (latest stable version) on AWS EC2 (or recommend an optimal setup).
• Define database schema for storing time-series trading data:
• Market data (price, volume, bid/ask spreads).
• Trading signals (buy/sell triggers, indicators).
• Order execution metrics (latency, slippage, PnL tracking).
• Set up optimal retention policies for different types of data.
• Ensure efficient indexing and query optimization for backtesting and live trading.
2. InfluxDB → Prometheus Integration
• Configure an InfluxDB Exporter to expose time-series data in a Prometheus-compatible format.
• Ensure correct labeling and formatting so that Prometheus can scrape the data properly.
• Test and validate data consistency between InfluxDB and Prometheus.
3. Monitoring & Visualization
• Integrate with Grafana to visualize:
• Market data (real-time price movements).
• Trading signals (indicator triggers).
• Order execution metrics (trade success/failure rates).
• Set up basic alerting rules in Prometheus (e.g., execution failure alerts).
This system will store and analyze market data, trading signals, and execution metrics, with real-time dashboards in Grafana.
Scope of Work
1. InfluxDB Setup
• Install and configure InfluxDB (latest stable version) on AWS EC2 (or recommend an optimal setup).
• Define database schema for storing time-series trading data:
• Market data (price, volume, bid/ask spreads).
• Trading signals (buy/sell triggers, indicators).
• Order execution metrics (latency, slippage, PnL tracking).
• Set up optimal retention policies for different types of data.
• Ensure efficient indexing and query optimization for backtesting and live trading.
2. InfluxDB → Prometheus Integration
• Configure an InfluxDB Exporter to expose time-series data in a Prometheus-compatible format.
• Ensure correct labeling and formatting so that Prometheus can scrape the data properly.
• Test and validate data consistency between InfluxDB and Prometheus.
3. Monitoring & Visualization
• Integrate with Grafana to visualize:
• Market data (real-time price movements).
• Trading signals (indicator triggers).
• Order execution metrics (trade success/failure rates).
• Set up basic alerting rules in Prometheus (e.g., execution failure alerts).