Moving average signals with QuestDB, Grafana and Coinbase

QuestDB, an open-source database optimized for handling market data, is used to analyze trading signals through moving averages as shown in a Grafana dashboard with Coinbase crypto data as the source. The article explores how technical analysis, specifically moving averages, can suggest potential trading actions when different time interval averages intersect. The process involves creating an indicator by incorporating a second moving average with a distinct period, then generating a signal when these averages cross to determine trade direction. By examining the sign change of this difference, traders can identify the appropriate trading moment. Additionally, the profitability and risk-adjusted returns of such strategies are considered, with a demonstration of simulating trades whenever signals are triggered, though the method's efficiency and profitability remain uncertain.