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