This chart presents the rolling percentage gains for BNB (Binance Coin) across multiple holding periods—one week, one month, three months, six months, and one year—since April 2022. By repurposing and adapting CryptoQuant’s original TRX rolling gains code, I customized the SQL logic for BNB, allowing for a granular analysis of investment performance over distinct time horizons.
The SQL script calculates daily BNB closing prices and then computes percentage changes for each holding period (relative to the price n days ago). Visualizing these rolling returns helps investors assess the volatility and cyclical nature of BNB’s price movements:
Short-term (1 week, 1 month):
These lines reflect rapid, often volatile changes which can be influenced by short-term news, market cycles, or broader crypto sentiment shifts.
Medium-term (3 and 6 months):
These trends provide insight into mid-cycle price momentum, capturing both recoveries and sustained rallies or downturns.
Long-term (1 year):
The one-year returns highlight the broader market regime shifts—periods of strong bull or bear markets, and when holding BNB long-term historically paid off the most.
Notably, the dramatic spikes in the one-year and six-month holding gains during 2024–2025 indicate periods of significant price appreciation, which gradually reverted as the market corrected. The recent convergence of all holding periods around the zero line shows a reduction in both volatility and directional conviction, potentially signaling a market equilibrium or consolidation phase.
This rolling window approach provides a dynamic performance measure for both traders and long-term holders.
Written by CryptoOnchain
