1WITH
2  bank_credit AS (
3    SELECT
4      DATE_TRUNC('month', date::DATE) AS period,
5      AVG(value_raw) AS bank_credit_millions_usd
6    FROM
7      "@fred.money_banking_finance.observations"
8    WHERE
9      series_id = 'TOTALSL' -- Total Bank Credit
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(b.period, s.period) AS date,
28  ROUND(b.bank_credit_millions_usd, 0) AS bank_credit_millions_usd,
29  ROUND(s.sp500_index, 0) AS sp500_index
30FROM
31  bank_credit b
32  FULL OUTER JOIN sp500 s ON b.period = s.period
33ORDER BY
34  date ASC