/* GET MIN ASK */
            SET MIN_ASK = (
                SELECT MIN(ASK_PRICE)
                FROM `STOCK_QUOTE_FEED_JW`
                WHERE (ASK_PRICE <= NEW.BID_PRICE AND TRADING_SYMBOL = NEW.TRADING_SYMBOL));
            /* PICK ASK WITH EARLIEST TIME */
            SET MIN_QUOTE_TIME = (
                SELECT MIN(QUOTE_TIME)
                FROM `STOCK_QUOTE_FEED_JW`
                WHERE (BID_PRICE = MIN_ASK AND TRADING_SYMBOL = NEW.TRADING_SYMBOL));
            /* GET MAX ASK SIZE FROM MIN ASK */
            SET MAX_ASK_SIZE = (
                SELECT ASK_SIZE
                FROM `STOCK_QUOTE_FEED_JW`
                WHERE (BID_PRICE = MIN_ASK AND QUOTE_TIME = MIN_QUOTE_TIME AND TRADING_SYMBOL = NEW.TRADING_SYMBOL)));
            /* FIGURE SIZE OF TRADE BASED ON THE SMALLEST BID/ASK SIZE*/
            IF MAX_ASK_SIZE > NEW.BID_SIZE THEN
                SET TRADE_SIZE = NEW.BID_SIZE;
                SET NEW.BID_SIZE = 0;
            ELSE
                SET TRADE_SIZE = MAX_ASK_SIZE;
                SET NEW.BID_SIZE = NEW.BID_SIZE - TRADE_SIZE;
            END IF;
            /* UPDATE ASK SIZE */
            UPDATE `STOCK_QUOTE_FEED_JW`
                SET ASK_SIZE = MAX_ASK_SIZE - TRADE_SIZE
                WHERE (ASK_PRICE = MIN_ASK AND QUOTE_TIME = MIN_QUOTE_TIME AND ASK_SIZE = MAX_ASK_SIZE);