让数据分析
精准高效

-- 最近 30 天期货品种涨跌幅排行
SELECT
  symbol,
  name,
  ROUND((close - open)
    / open * 100, 2) AS change_pct
FROM futures_daily
WHERE trade_date >= CURRENT_DATE - 30
ORDER BY change_pct DESC
LIMIT 20;