Metrics in the research desk

Querying Thrive Metrics

Thrive Metrics are fully accessible in the research desk via two SQL tables:thrive_metrics (latest per asset) andthrive_metrics_history (hourly time-series, 90-day retention).

Example Queries

Top Assets by Power Score

SELECT asset, tps, tps_grade, tas, tas_signal, trp_regime, trp_intensity
FROM thrive_metrics
ORDER BY tps DESC
LIMIT 10;

Assets with Strong Long Signals

SELECT asset, tps, tas, trp_regime
FROM thrive_metrics
WHERE tas > 50 AND tps > 65
ORDER BY tas DESC;

Current Regime Distribution

SELECT trp_regime, COUNT(*) as asset_count, ROUND(AVG(trp_intensity)) as avg_intensity
FROM thrive_metrics
GROUP BY trp_regime
ORDER BY asset_count DESC;

TPS Trend Over 7 Days

SELECT asset, DATE(computed_at) as date, ROUND(AVG(tps), 1) as avg_tps
FROM thrive_metrics_history
WHERE asset = 'BTC' AND computed_at > NOW() - INTERVAL '7 days'
GROUP BY asset, DATE(computed_at)
ORDER BY date;

Live Data Feed

Thrive Metrics are also available as a live data source in workbench widgets. Selectthrive_metricsfrom the live data source dropdown to stream the latest scores in real-time dashboard widgets.

Dashboard Widgets

Create dashboard widgets that display Thrive Metrics as counters, charts, or tables. Popular configurations include: