trivial sql. but why a few seconds should be milliseconds.Yes ?
if I give you bulk of data can you pull all stocks that had earnings on the day, gapped 30 %, spiked 10% in the first 30 min of mkt open had a low price in the first 30 min which is lower than the low price in first 60 mins, broke out through the 200 MA, below VWAP, etc etc, all in a few seconds ?
this is just scanning constraints and boundary conditions. it's not even realtime. focus on graphics and visuals... the masses like hypnosis
