check_skedNet Liquidity (Wednesday Level)
Updated 2024-08-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH all_data AS (
SELECT
f.value:date AS dt,
f.value:value::FLOAT AS EFFR,
'RESPPANWW' AS source
FROM
(SELECT
PARSE_JSON(resp):data:observations AS obs
FROM (
SELECT
fred.get_series({
'series_id': 'RESPPANWW',
'file_type': 'json'
}) AS resp
) AS data
) AS flattened,
LATERAL FLATTEN(input => obs) f
UNION ALL
SELECT
f.value:date AS dt,
f.value:value::FLOAT AS EFFR,
'D2WLTGAL' AS source
FROM
(SELECT
PARSE_JSON(resp):data:observations AS obs
FROM (
SELECT
fred.get_series({
'series_id': 'D2WLTGAL',
'file_type': 'json'
}) AS resp
) AS data
) AS flattened,
LATERAL FLATTEN(input => obs) f
QueryRunArchived: QueryRun has been archived