Get the 3-day forecast % change for a specific crypto (edit the symbol)

The query

SELECT (payload->>'pct')::float AS forecast_change_pct_3d
FROM ticker_analysis
WHERE ticket = 'BTC-USD' AND analysis_type = 'forecast_3d'

Runs against Cryptobi's market tables — ticketname (symbols), ticketprice (daily prices and volume) and symbolmetadata (sector, exchange, market cap and other reference fields).

Current output

Live output, first 1 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.

Related calculations

• Get the 7-day forecast price for a specific stock (edit the symbol)
• Get the 30-day forecast price for a specific fund (edit the symbol)
• Top 10 stocks by 7-day forecasted % gain, market-wide
• Show a symbol's recent price trend with its 7-day and 30-day forecast overlaid (edit the symbol)