Crypto: volatility & risk
For crypto risk managers and allocators
How violently tokens move, how deep their drawdowns run and how fat their tails are.
- Financial markets
- 6 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Realized volatility of the largest tokens
Short-, medium- and long-run realized volatility. Crypto volatility is typically three to five times that of the major currencies.
GET (BTCUSD, ETHUSD, SOLUSD) SELECT symbol, rv_cc(20) AS vol_20d, rv_cc(60) AS vol_60d, rv_cc(252) AS vol_1y, natr(14)
Bitcoin volatility report
Realized volatility on several windows, its percentile against history and the current regime.
ANALYZE volatility BTCUSD
Ether drawdowns
The deepest declines in Ether, how long each lasted and whether it has recovered.
ANALYZE drawdowns ETHUSD
Bitcoin's return distribution
Skew, fat tails and the share of extreme days: how far Bitcoin's daily returns are from a normal distribution.
ANALYZE distribution BTCUSD
Biggest Bitcoin days since 2019
The 20 largest daily moves in Bitcoin, weekends included.
SELECT timestamp, close, ret FROM bars WHERE symbol = 'BTCUSD' AND timestamp >= '2019-01-01' ORDER BY abs(ret) DESC LIMIT 20
Volatility of the largest tokens this year
Annualized volatility (365 days, as crypto trades daily) with the worst and best days, for nineteen of the largest tokens.
SELECT symbol, stddev(ret) * sqrt(365) * 100 AS vol_pct, min(ret) AS worst_day, max(ret) AS best_day FROM bars WHERE symbol IN ('BTCUSD', 'ETHUSD', 'SOLUSD', 'XRPUSD', 'BNBUSD', 'ADAUSD', 'TRXUSD', 'AVAXUSD', 'LINKUSD', 'DOTUSD', 'LTCUSD', 'BCHUSD', 'XLMUSD', 'NEARUSD', 'UNIUSD', 'APTUSD', 'ATOMUSD', 'ETCUSD', 'FILUSD') AND timestamp >= '2026-01-01' GROUP BY symbol HAVING count(*) > 100 ORDER BY vol_pct DESC LIMIT 25
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.