-- Hapus baris duplikat, pertahankan 1 per ticker+date+time+algo
-- Jika value_raw lengkap → prioritaskan. Jika sama → pertahankan id terbesar
DELETE FROM signals
WHERE id IN (
  SELECT id FROM (
    SELECT id,
      ROW_NUMBER() OVER (
        PARTITION BY ticker, signal_date, signal_time, algo_key
        ORDER BY
          CASE WHEN value_raw IS NOT NULL AND value_raw != '0' THEN 0 ELSE 1 END,
          id DESC
      ) AS rn
    FROM signals
  ) ranked
  WHERE rn > 1
);

-- Hapus baris yang field pentingnya kosong (data kotor tanpa ticker/price)
DELETE FROM signals WHERE ticker IS NULL OR price IS NULL OR price = 0;

-- Hapus sinyal tanpa harga (tidak sempurna / gagal parse)
DELETE FROM signals WHERE price IS NULL OR price = 0;