Query 1

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

SQL

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

Last modified: March 2, 2021

Was this article helpful?