SELECT * FROM (
  select t.*, row_number() over(partition by trunc(buy_time), good_id order by buy_time desc) AS row1
  from TMP_T1 T
) WHERE row1 = 1;