create table a ( i int, s symbol, ts timestamp ) timestamp(ts);

select s, i, ts 
from a 
where s in (select distinct s from a) 
and s = 'ABC' <-- fixed filter 
latest on ts partition by s;