直近１年の各月末日の連続データ

SELECT CAST(DATE_TRUNC('month', GENERATE_SERIES(CURRENT_DATE + CAST('-1 year' AS INTERVAL), CURRENT_DATE, '1 month')) + '-1 day' AS DATE);