Postgres сумма за разные интервалы?

SELECT
    d.*,
    sum(d.day_sum) OVER (PARTITION BY date_trunc('month', d.f_timestamp)) as month_sum
FROM (
        SELECT
            f_timestamp::date,
            sum(value::real) as day_sum
        FROM analiz_data
        GROUP BY f_timestamp::date
    ) d

select
sum(value::REAL) as month_sum,
sum(case when CURRENT_DATE =f_timestamp::date then value::REAL else 0 end) as today_sum
from analiz_data where to_char(current_timestamp, 'YYYY-MM') = to_char(f_timestamp, 'YYYY-MM')