SELECT
date_trunc('day', block_timestamp) as day,
SUM(amount_usd) as uni_amount_usd,
COUNT(DISTINCT tx_id) as uni_num_tx,
COUNT(DISTINCT from_address) as uni_users,
case WHEN (day >= '2022-02-24') then 'Ukraine war'
else 'other days' end as specific_time
FROM ethereum.dex_swaps
WHERE platform LIKE '%uni%'
AND day >= '2022-01-01'
AND day < '2022-04-20'
GROUP BY 1
ORDER BY 1