Crypto: trend & momentum
For crypto trend followers and quant funds
Trend and momentum for the largest tokens, which carry live indicators, and return rankings from daily history (a bar for every calendar day) for every token.
- 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.
Bitcoin, Ether, Solana: trend table
Each against its 50- and 200-day averages (calendar days for crypto), with RSI, trend strength and distance from the 52-week high.
GET (BTCUSD, ETHUSD, SOLUSD) SELECT symbol, close, sma(50), sma(200), rsi(14), adx(14), dist_high(252)
Momentum ranking of the majors
One-week, one-month and three-month returns. Crypto has seven bars a week, so roc(30) is a calendar month.
GET (BTCUSD, ETHUSD, SOLUSD) SELECT symbol, close, roc(7) AS one_week, roc(30) AS one_month, roc(90) AS three_months SORT one_month DESC
Bitcoin over the past year
A year of Bitcoin with its averages and RSI, ready to chart.
GET BTCUSD SELECT close, sma(50), sma(200), rsi(14) LAST 1y
The largest tokens: 30-day performance
Nineteen of the largest tokens ranked by their return over the last 30 days, from daily history. Edit the list for any tokens.
SELECT symbol, sum(ret) AS ret_30d, count(*) AS days 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 >= dateadd('d', -30, today()) GROUP BY symbol HAVING count(*) >= 25 ORDER BY ret_30d DESC LIMIT 25Monthly returns of Bitcoin and Ether
Month-by-month returns for the two largest tokens: the raw material for a heatmap.
SELECT symbol, date_trunc('month', timestamp) AS month, sum(ret) AS month_ret FROM bars WHERE symbol IN ('BTCUSD', 'ETHUSD') AND timestamp >= '2024-01-01' GROUP BY symbol, month ORDER BY month, symbolEther against Bitcoin
The ETH/BTC ratio day by day. A rising line means Ether is outperforming, the usual sign of risk appetite within crypto.
WITH e AS (SELECT timestamp, close AS eth FROM bars WHERE symbol = 'ETHUSD' AND timestamp >= '2025-01-01'), b AS (SELECT timestamp, close AS btc FROM bars WHERE symbol = 'BTCUSD' AND timestamp >= '2025-01-01') SELECT e.timestamp, e.eth / b.btc AS eth_btc FROM e JOIN b ON e.timestamp = b.timestamp ORDER BY e.timestamp
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.