1WITH
2  fed AS (
3    SELECT
4      DATE_TRUNC('month', date)::DATE AS month,
5      AVG(value) AS fed_funds_rate
6    FROM
7      "@fred.money_banking_finance.observations"
8    WHERE
9      series_id = 'FEDFUNDS'
10      AND date >= '2021-01-01'
11    GROUP BY
12      DATE_TRUNC('month', date)
13  ),
14  defi AS (
15    SELECT
16      DATE_TRUNC('month', "timestamp")::DATE AS month,
17      AVG(tvl) / 1e9 AS avg_tvl_billions
18    FROM
19      "@defillama.tvl.daily_tvl"
20    WHERE
21      "timestamp" >= '2021-01-01'
22    GROUP BY
23      DATE_TRUNC('month', "timestamp")
24  )
25SELECT
26  fed.month,
27  fed.fed_funds_rate,
28  defi.avg_tvl_billions
29FROM
30  fed
31  JOIN defi ON fed.month = defi.month
32ORDER BY
33  fed.month ASC