1WITH
2  retail_sales AS (
3    SELECT
4      DATE_TRUNC('month', date::DATE) AS period,
5      AVG(value_raw) AS retail_sales_millions_usd
6    FROM
7      "@fred.production_business_activity.observations"
8    WHERE
9      series_id = 'RSXFS' -- Retail Sales
10      AND date >= '2016-01-01'
11    GROUP BY
12      DATE_TRUNC('month', date::DATE)
13  ),
14  sp500 AS (
15    SELECT
16      DATE_TRUNC('month', date::DATE) AS period,
17      AVG(value_raw) AS sp500_index
18    FROM
19      "@fred.money_banking_finance.observations"
20    WHERE
21      series_id = 'SP500'
22      AND date >= '2016-01-01'
23    GROUP BY
24      DATE_TRUNC('month', date::DATE)
25  )
26SELECT
27  COALESCE(r.period, s.period) AS date,
28  ROUND(r.retail_sales_millions_usd, 0) AS retail_sales_millions_usd,
29  ROUND(s.sp500_index, 0) AS sp500_index
30FROM
31  retail_sales r
32  FULL OUTER JOIN sp500 s ON r.period = s.period
33ORDER BY
34  date ASC