LordkingDEXUSAL
    Updated 2025-04-10





    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
    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
    ...
    313
    9KB
    11s