Determine the top 10 most active stocks using tick_qry4. Find the 10 stocks with the highest percentage spreads using tick_qry6.
Determine the top 10 most active stocks for a specified date, sorted by cumulative trade volume, by considering all trades.
TRADING_SYMBOL TRADESIZE AJC 269100 AWO 250900 ASZ 249000 AHI 230600 AKX 225600 AKD 222000 AZO 221200 BED 220300 AMW 219400 AQD 219100
Find the 10 stocks with the highest percentage spreads. Spread is the difference between the last ask-price and the last bid-price. Percentage spread is calculated as a percentage of the bid-point price (average of ask and bid price).
TRADING_SYMBOL PER ARG 0.005943536404160475482912 ACV 0.005161802660313678777049 BEY 0.004888481515429269783073 AJE 0.004440649017933390264730 AMX 0.004440649017933390264730 AUM 0.004429678848283499446290 AKO 0.004239084357778719796523 AUN 0.004237288135593220338983 BED 0.004135338345864661654135 AJM 0.004063134864822628535708