Try the FROM_UNIXTIME() function instead
FROM_UNIXTIME(qz.timeopen) > '2021-01-01' AND FROM_UNIXTIME(qz.timeclose) < '2023-01-30'
Try the FROM_UNIXTIME() function instead
FROM_UNIXTIME(qz.timeopen) > '2021-01-01' AND FROM_UNIXTIME(qz.timeclose) < '2023-01-30'