Loading...Loading chart...
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