SELECT
        market,
        COUNT(
            DISTINCT meaning_quantity
        ) AS quantity,
        DATE(timestamp) AS term
    FROM
        dce_machine.result
    WHERE
        DATE(timestamp) BETWEEN '2018-07-01 00:00:00' AND '2018-07-19 00:00:00'
            AND is_first != 1
    GROUP BY
        DATE(timestamp), market
    ORDER BY
        DATE(timestamp), market
    ;