Query 1

Finds the most traded stocks. This query is very fast over very large volumes of data.

SELECT stock_symbol, COUNT(*) AS c
  FROM trade
  GROUP BY stock_symbol
  ORDER BY c DESC limit 10;