case when date < '2022-11-08' then 'Before Collapse'

when date >= '2022-11-08' and date <= '2022-11-10' then 'Main Collapse Days'

when date > '2022-11-10' then 'After Collapse' end as timespan,

count (distinct recipient) as New_Users

from (

select recipient,

min (block_timestamp) as mindate

from ethereum.uniswapv3.ez_swaps

group by 1)

where mindate >= '2022-10-25' and mindate::date != CURRENT_DATE

group by 1,2