EquationDB

Crypto: cross-asset

For cross-asset allocators and macro funds

Is crypto a tech trade, a dollar trade or a diversifier? Correlations and betas against stocks, gold and currencies.

  • 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 vs the Nasdaq

    Correlation and beta of Bitcoin's daily returns to QQQ: is Bitcoin trading as a leveraged tech bet? The join keeps days both traded.

    WITH b AS (SELECT timestamp, ret AS btc FROM bars WHERE symbol = 'BTCUSD' AND timestamp >= '2025-01-01'), q AS (SELECT timestamp, ret AS ndx FROM bars WHERE symbol = 'QQQ' AND timestamp >= '2025-01-01') SELECT corr(b.btc, q.ndx) AS corr, beta(b.btc, q.ndx) AS beta_to_nasdaq, count(*) AS days FROM b JOIN q ON b.timestamp = q.timestamp
    Try it →
  2. Bitcoin vs gold

    The digital-gold question in one number: a correlation near zero says Bitcoin is not trading as gold.

    WITH b AS (SELECT timestamp, ret AS btc FROM bars WHERE symbol = 'BTCUSD' AND timestamp >= '2025-01-01'), g AS (SELECT timestamp, ret AS gold FROM bars WHERE symbol = 'GLD' AND timestamp >= '2025-01-01') SELECT corr(b.btc, g.gold) AS corr, beta(b.btc, g.gold) AS beta_to_gold, count(*) AS days FROM b JOIN g ON b.timestamp = g.timestamp
    Try it →
  3. Crypto, stocks and gold: correlations

    One year of pairwise correlations: how much diversification a crypto sleeve really adds.

    ANALYZE correlation (BTCUSD, ETHUSD, SOLUSD, QQQ, GLD) LAST 1y
    Try it →
  4. Bitcoin and the dollar

    Bitcoin against an equal-weight dollar index from the seven majors. A negative beta means Bitcoin tends to rise when the dollar weakens.

    WITH fx AS (SELECT timestamp, avg(CASE WHEN starts_with(symbol, 'USD') THEN ret ELSE -ret END) AS usd FROM bars WHERE symbol IN ('EURUSD', 'USDJPY', 'GBPUSD', 'USDCHF', 'AUDUSD', 'USDCAD', 'NZDUSD') AND timestamp >= '2025-01-01' GROUP BY timestamp), b AS (SELECT timestamp, ret AS btc FROM bars WHERE symbol = 'BTCUSD' AND timestamp >= '2025-01-01') SELECT corr(b.btc, fx.usd) AS corr, beta(b.btc, fx.usd) AS beta_to_usd, count(*) AS days FROM b JOIN fx ON b.timestamp = fx.timestamp
    Try it →
  5. Bitcoin vs Ether as a pair

    Hedge ratio, correlation, the spread's z-score and its half-life: the standard check before trading ETH/BTC relative value.

    ANALYZE pairs BTCUSD VS ETHUSD
    Try it →
  6. Crypto next to stocks and gold

    Returns, volatility, drawdown and Sharpe ratio for crypto against tech stocks and gold over the same window.

    ANALYZE compare (BTCUSD, ETHUSD, QQQ, GLD)
    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