EquationDB

Crypto: backtests & seasonality

For systematic crypto traders

Trend, breakout and mean-reversion rules on the largest tokens, and the weekend and calendar effects that only a 24/7 market has.

  • 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. Backtest a Bitcoin trend rule

    Long Bitcoin above a rising trend structure, flat otherwise, against buy-and-hold. sma(50) is 50 calendar days.

    BACKTEST IN BTCUSD SINCE 2020-01-01 ENTER WHEN close > sma(50) AND sma(50) > sma(200) EXIT WHEN close < sma(50) COST 10 bps
    Try it →
  2. Breakouts across the majors

    Buy a new 30-day high, exit on a 10-day low, across Bitcoin, Ether and Solana.

    BACKTEST IN (BTCUSD, ETHUSD, SOLUSD) SINCE 2020-01-01 ENTER WHEN close CROSS ABOVE highest(high, 30)[-1] EXIT WHEN close < lowest(low, 10)[-1] COST 10 bps
    Try it →
  3. Buying sharp dips in Ether

    Short-term mean reversion inside an uptrend, with a wide stop for crypto volatility.

    BACKTEST IN ETHUSD SINCE 2020-01-01 ENTER WHEN rsi(2) < 10 AND close > sma(200) EXIT WHEN close > sma(5) STOP 15% COST 10 bps
    Try it →
  4. What happens after Bitcoin turns oversold

    Forward one-week and one-month returns after an oversold signal, with hit rates, against the unconditional average.

    OUTCOMES AFTER rsi(14) CROSS BELOW 30 IN (BTCUSD, ETHUSD, SOLUSD) SINCE 2019-01-01 FWD 7d, 30d
    Try it →
  5. Weekend crypto moves

    Average return, volatility and move size by weekday (0 = Sunday, 6 = Saturday). Weekends are real sessions and usually quieter.

    SELECT symbol, day_of_week(timestamp) AS dow, count(*) AS days, avg(ret) AS avg_ret, stddev(ret) AS vol, avg(abs(ret)) AS avg_abs_move FROM bars WHERE symbol IN ('BTCUSD', 'ETHUSD') AND timestamp >= '2024-01-01' GROUP BY symbol, dow ORDER BY symbol, dow
    Try it →
  6. Bitcoin by month of the year

    Average return and hit rate for each calendar month across Bitcoin's history.

    ANALYZE seasonality BTCUSD
    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