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.
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
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
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
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.timestampBitcoin 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
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)
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.