-- 某只股票最近的舆情SELECT date, title, abstract, provider, evaluationFROM news_001_sentimentWHERE instrument = '600519.SH' AND date >= '2026-10-01'ORDER BY date DESC
sql
-- 每日各股票的利好、利空舆情数SELECT CAST(date AS DATE) AS day, instrument, count(*) FILTER (WHERE evaluation = '利好') AS positive, count(*) FILTER (WHERE evaluation = '利空') AS negativeFROM news_001_sentimentWHERE date >= '2026-11-01' AND date < '2026-11-08'GROUP BY day, instrumentORDER BY day, instrument