thinking about rolling time windows for dex data in substrate-based chains

The post discusses patterns for handling time-bucketed metrics (5m, 1h, 6h, 24h rolling windows) when working with real-time DEX data on Substrate-based chains. Pre-computing rolling windows server-side and streaming them as part of pair updates avoids client-side state management across thousands of pairs, though edge cases around window boundaries and disconnects require periodic reconciliation against historical endpoints. The author notes GoldRush's updatePairs streaming endpoint now supports multi-window trading metrics.