EquationDB

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.

  1. 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)
    Try it →
  2. 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
    Try it →
  3. 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
    Try it →
  4. 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 25
    Try it →
  5. Monthly 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, symbol
    Try it →
  6. Ether 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
    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