> For the complete documentation index, see [llms.txt](https://docs.koinju.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.koinju.io/sql-cookbook.md).

# SQL Cookbook

- [Introduction](https://docs.koinju.io/sql-cookbook/introduction.md)
- [Backtesting simple SMA strategy](https://docs.koinju.io/sql-cookbook/backtesting-simple-sma-strategy.md)
- [Historical volatility](https://docs.koinju.io/sql-cookbook/historical-volatility.md)
- [Sortino ratio](https://docs.koinju.io/sql-cookbook/sortino-ratio.md)
- [Maximum drawdown & Calmar ratio](https://docs.koinju.io/sql-cookbook/max-drawdown-calmar.md)
- [Correlation](https://docs.koinju.io/sql-cookbook/correlation.md)
- [Mean reversion z-score](https://docs.koinju.io/sql-cookbook/mean-reversion-zscore.md)
- [DCA vs Lump-Sum](https://docs.koinju.io/sql-cookbook/dca-vs-lump-sum.md)
- [Bollinger Bands](https://docs.koinju.io/sql-cookbook/bollinger-bands.md)
- [Cross-exchange arbitrage](https://docs.koinju.io/sql-cookbook/cross-exchange-arbitrage.md)
- [Deribit perpetual funding](https://docs.koinju.io/sql-cookbook/deribit-perpetual-funding.md)
- [Spot / Futures / Perp Spreads](https://docs.koinju.io/sql-cookbook/spot-futures-perp-spreads.md)
- [OHLCV streaming download](https://docs.koinju.io/sql-cookbook/ohlcv-streaming.md)
- [Multi-exchange vol surface](https://docs.koinju.io/sql-cookbook/multi-exchange-vol-surface.md)