SELECT DISTINCT ON (sensor_id, dedup_key) * FROM transformed_data ORDER BY sensor_id, dedup_key, temp;
SELECT sensor_id, timestamp + INTERVAL '600 seconds' - (code_offset || ' seconds')::INTERVAL AS dedup_key, temp FROM raw_weather; Intv Plus Code-
SELECT DISTINCT ON (sensor_id, dedup_key) * FROM transformed_data ORDER BY sensor_id, dedup_key, temp;
SELECT sensor_id, timestamp + INTERVAL '600 seconds' - (code_offset || ' seconds')::INTERVAL AS dedup_key, temp FROM raw_weather;