Build Custom App for Polygon.io WebSockets – Real-Time & Historical Market Data to PostgreSQL with Dashboard

We are looking for an experienced developer (or team) to create a custom application that connects to the Polygon.io WebSockets and REST APIs to collect and store real-time and historical market data.

The data must be stored in our own PostgreSQL database, with support for multiple timeframes (tick, 1s, 1m, 5m, 1h, etc.). The project includes building a control panel (dashboard) to manage instruments, view data coverage, and monitor live data flow.

Project Requirements
✅ Data Collection
Connect to Polygon.io WebSocket & REST APIs.

Collect both live and historical data.

Support for:

Forex (FX)

US Stocks

Indices

Crypto

Store in PostgreSQL:

Raw tick/trade data

Aggregated OHLC bars (1s, 1m, 5m, 1h, etc.)

✅ Backend
Language: Python (FastAPI/Flask) or Node.js.

Store all market data in a PostgreSQL database.

Efficient indexing and schema design to support high-frequency data.

Include logic to:

Aggregate timeframes (if not available from Polygon)

Handle large data volumes efficiently

✅ Control Panel / Admin Dashboard
Web-based frontend built with React, Vue, or similar.

Features:

Instrument management per asset class

Start/stop data collection for individual symbols

View data coverage per instrument and timeframe

Real-time WebSocket connection status

System health monitoring and logs

Secure admin login

✅ Failover and Reliability
Automatic WebSocket reconnects on failure

API limit detection and handling

Logging for all errors and issues

Optional email or webhook alerts for failures