WITH INTERVALO_30 AS(
SELECT CAST(EXTRACT(YEAR FROM CURRENT_DATE-30)||'-'||EXTRACT(MONTH FROM CURRENT_DATE-30)||'-01' AS DATE) AS DATA_INI,
(DATE_TRUNC('MONTH', CURRENT_DATE-30) + INTERVAL '1 MONTH - 1 DAY')::DATE AS DATA_FIM
)
SELECT DATA_INI, DATA_FIM
FROM INTERVALO_30