TIMES | DATE | NUMBERS | |
---|---|---|---|
1 | after | 2025-04-01 | 0.6278 |
2 | after | 2025-03-31 | 0.6236 |
3 | after | 2025-03-28 | 0.63 |
4 | after | 2025-03-27 | 0.6308 |
5 | after | 2025-03-26 | 0.6307 |
6 | after | 2025-03-25 | 0.6309 |
7 | after | 2025-03-24 | 0.6281 |
8 | after | 2025-03-21 | 0.6266 |
9 | after | 2025-03-20 | 0.6301 |
10 | after | 2025-03-19 | 0.6331 |
11 | after | 2025-03-18 | 0.6356 |
12 | after | 2025-03-17 | 0.6375 |
13 | after | 2025-03-14 | 0.6318 |
14 | after | 2025-03-13 | 0.6289 |
15 | after | 2025-03-12 | 0.6306 |
16 | after | 2025-03-11 | 0.6285 |
17 | after | 2025-03-10 | 0.6308 |
18 | after | 2025-03-07 | 0.63 |
19 | after | 2025-03-06 | 0.6348 |
20 | after | 2025-03-05 | 0.6312 |
LordkingDEXUSAL
Updated 2025-04-10
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
base AS (
SELECT
fred.get_series({
'series_id': 'DEXUSAL',
'file_type': 'json',
'observation_start': '2024-01-01',
'observation_end': '2025-04-01',
'units': 'lin',
'frequency': 'd',
'sort_order': 'desc'
}) AS response
)
,fred as (
SELECT
value:date AS date,
value:value::float AS numbers
FROM base,
LATERAL FLATTEN(input => response:data:observations)
WHERE value:value != '.'
)
select
case when date >'2025-01-06' then 'after' else 'before' end as times,
date,
numbers
from fred
Last run: 2 months ago
...
313
9KB
11s