SELECT
DISTINCT date_trunc('day', "s"."timestamp") AS "day",
FIRST_VALUE("s"."data"::jsonb) OVER (PARTITION BY date_trunc('day', "s"."timestamp")) AS "dat"
FROM
(SELECT "data", "timestamp" FROM "table" ORDER BY "timestamp" DESC) AS "s"
ORDER BY "day" DESC
$('.sh_num, .sh_num2').click()