WITH

base AS (

SELECT

fred.get_series({

'series_id': '{{index}}',

'file_type': 'json',

'observation_start': '{{From_date}}',

'observation_end': '{{To_date}}',

'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 >= '2018-03-01' AND date <= '2018-03-08' THEN 'Start: Steel & Aluminum Tariffs'

WHEN date >= '2018-06-15' AND date <= '2018-06-30' THEN 'China Tariffs - Round 1 ($34B)'

WHEN date >= '2018-08-01' AND date <= '2018-08-30' THEN 'China Tariffs - Round 2 ($16B)'

WHEN date >= '2018-09-01' AND date <= '2018-12-31' THEN 'China Tariffs - Round 3 ($200B)'

WHEN date >= '2020-01-01' AND date <= '2020-01-31' THEN 'Phase One Deal Signed'