block_timestamp:: date date,

case

when date BETWEEN '2021-05-01' and '2021-06-10' then 'Raise'

when date BETWEEN '2021-06-11' and '2021-08-05' then 'Reduce'

when date BETWEEN '2021-08-06' and '2022-01-24' then 'Raise'

when date BETWEEN '2022-01-25' and '2022-03-13' then 'Reduce'

when date BETWEEN '2022-03-14' and '2022-04-10' then 'Raise'

else 'Reduce'

end grp,

sum(amount_usd) loan_amount,

count(distinct(tx_id)) loan_volume

ethereum.udm_events

symbol = 'DAI'

and from_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'

and origin_function_name = 'execute'

and (

date between '2021-05-01' and '2022-04-30'

)

group by

1