declare
  tts_ timestamptz;
begin
  tts_ = date_trunc( 'minute', new."TTS" );

  update "RIM_TOD_MIN" set
    "OPEN" = case
      when new."TTS" < "TTS_OPEN" then new."LAST"
      else "OPEN" end,
    "HIGH" = case
      when new."LAST" > "HIGH" then new."LAST"
      else "HIGH" end,
    "LOW" = case
      when new."LAST" < "LOW" then new."LAST"
      else "LOW" end,
    "CLOSE" = case
      when new."TTS" > "TTS_CLOSE" then new."LAST"
      else "CLOSE" end,
    "VOL" = "VOL"+new."VOLLOT",
    "TTS_OPEN" = case
      when new."TTS" < "TTS_OPEN" then new."TTS"
      else "TTS_OPEN" end,
    "TTS_CLOSE" = case
      when new."TTS" >= "TTS_CLOSE" then new."TTS"
      else "TTS_CLOSE" end
    where "TTS"=tts_ and "NAME"=new."NAME";
  if not found
  then

    insert into "RIM_TOD_MIN"
      ( "NAME", "TTS",
        "OPEN", "HIGH", "LOW", "CLOSE", "VOL",
        "TTS_OPEN", "TTS_CLOSE" )
      values( new."NAME", tts_,
        new."LAST", new."LAST", new."LAST", new."LAST", new."VOLLOT",
        new."TTS", new."TTS" );
  end if;
  return null;
end

set local enable_seqscan = false;