EquationDB

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.

  1. 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)
    Try it →
  2. Bitcoin volatility report

    Realized volatility on several windows, its percentile against history and the current regime.

    ANALYZE volatility BTCUSD
    Try it →
  3. Ether drawdowns

    The deepest declines in Ether, how long each lasted and whether it has recovered.

    ANALYZE drawdowns ETHUSD
    Try it →
  4. 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
    Try it →
  5. 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
    Try it →
  6. 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
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More financial markets use cases