user_id  date     action_type_id
1   14-12-2019 00:00:01  1
1   14-12-2019 00:01:02  0

2   14-12-2019 00:05:00  1
2   14-12-2019 00:015:00  0

3   14-12-2019 00:05:00  0

4   14-12-2019 00:05:01  1

sult:
subscribers:     3 (1,2,4) где action_type == 1
unsubscribers: 3 (1,2,3) где action_type == 0 
spammers:        1 (1) где diff(date) > 60сек  
unsub_fr_sub:   2 (1,2) где есть action_type 1 и 0

create table Z Engine=Memory as 
select 1  user_id,  toDateTime('2019-12-14 00:00:01') date, 1 action_type_id  union all
select 1,   toDateTime('2019-12-14 00:01:02'),  0 union all
select 2,   toDateTime('2019-12-14 00:05:00'),  1 union all
select 2,   toDateTime('2019-12-14 00:15:00'),  0 union all
select 3,   toDateTime('2019-12-14 00:05:00'),  0 union all
select 4,   toDateTime('2019-12-14 00:05:01'),  1 ;

SELECT
    sum(subscriber) AS subscribers,
    sum(unsubscriber) AS unsubscribers,
    sum(spammer) AS spammers,
    sum(unsub_fr_sub) AS unsub_fr_subs
FROM
(
    SELECT
        user_id,
        max(action_type_id = 1) AS subscriber,
        max(action_type_id = 0) AS unsubscriber,
        length(arrayFilter((i, j) -> (abs(i - j) > 60), arrayPopBack(arraySort(groupArray(date)) AS d), arrayPopFront(d))) >= 1 AS spammer,
        subscriber AND unsubscriber AS unsub_fr_sub
    FROM Z
    GROUP BY user_id
)

┌─subscribers─┬─unsubscribers─┬─spammers─┬─unsub_fr_subs─┐
│           3 │             3 │        2 │             2 │
└─────────────┴───────────────┴──────────┴───────────────┘

select sum(subscriber) subscribers, sum(unsubscriber) unsubscribers, sum(spammer) spammers, sum(unsub_fr_sub) unsub_fr_subs
from (
   select user_id, 
       max(action_type_id=1) subscriber,
       max(action_type_id=0) unsubscriber,  
       length(arrayFilter(i,j -> abs(i.1-j.1)<60 and i.2<>j.2, arrayPopBack(arraySort(groupArray((date,action_type_id))) as d) ,arrayPopFront(d)))>=1 spammer,
       (subscriber and unsubscriber) unsub_fr_sub
   from Z group by user_id
)