Query description: tick_qry4 Determine the top 10 most active stocks for a specified date, sorted by cumulative trade volume, by considering all trades.
TRADING_SYMBOL TRADESIZE --------------- ----------- ASU 2932300 BEG 2929000 AYD 2923600 AJA 2884400 AVQ 2874300 AAC 2856400 AKC 2854900 ACN 2851800 AQL 2834100 AFE 2821600
Query description: tick_qry6 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 --------------- ---------------------------------- ACG 0.027027027027027027027027 ADC 0.018248175182481751824817 AFZ 0.018018018018018018018018 BBN 0.017654476670870113493064 ASS 0.017431725740848343986054 AUZ 0.016806722689075630252100 BGW 0.016051364365971107544141 AKF 0.015804597701149425287356 AUB 0.012652889076339097427245 AZY 0.012628255722178374112075
