Return changes between today and 1 year ago

return_changes_1year.sql

SELECT s.symbol, s.sector, first(close, date) AS first_close, last(close, date) AS last_close,
      MIN(date) AS first_date,
      MAX(date) AS last_date,
      100 * (last(close, date) - first(close, date)) / first(close, date) AS return_change
    FROM
      daily_bars db, stocks s
    WHERE
      db.date >= now() - interval '1 year' AND db.symbol = s.symbol
    GROUP BY
      s.symbol
    ORDER BY
      return_change DESC