Query 3

Finds the most volatile stocks (highest variance in prices) in the last 5 seconds.

SELECT stock_symbol, VARIANCE(share_price) var
FROM trade
WHERE trade_time * 1 > ( NOW() - 5 )
GROUP BY stock_symbol
ORDER BY var DESC;

Last modified:

Was this article helpful?