date_trunc('day', first_transaction_stamp) as day,

case

when first_transaction_stamp>='2022-08-04' and first_transaction_stamp<'2022-08-11' then 'week of attack'

when first_transaction_stamp>='2022-11-07' then 'Recent TX crisis'

else 'other days' end as gp,

count (distinct sender) as new_users

from (

select

distinct origin_from_address as sender,

min(block_timestamp) as first_transaction_stamp

from optimism.velodrome.ez_swaps

WHERE tx_hash is not null

group by 1

)

group by 1,2