from_unixtime("start", 'Asia/Tokyo') as start_time

SELECT *
FROM your_table_name -- あなたのテーブル名に置き換えてください
WHERE 
    date BETWEEN date_format(date_add('day', -1, current_date), '%Y/%m/%d') 
              AND date_format(current_date, '%Y/%m/%d') 
AND 
    parse_datetime(time, 'yyyy-MM-dd''T''HH:mm:ss.SSSSSS''Z') 
    BETWEEN current_timestamp - interval '1' hour
    AND current_timestamp
AND 
    "elb_status_code" LIKE '5%%';