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.
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
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
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
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
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, dowBitcoin by month of the year
Average return and hit rate for each calendar month across Bitcoin's history.
ANALYZE seasonality BTCUSD
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.