case when n_swaps >=200 THEN '>= 200'

when n_swaps >=100 THEN '>= 100'

WHEN n_swaps>=60 THEN '>= 060'

WHEN n_swaps>=50 THEN '>= 050'

WHEN n_swaps>=40 THEN '>= 040'

WHEN n_swaps>=30 THEN '>= 030'

WHEN n_swaps>=20 THEN '>= 020'

WHEN n_swaps>=10 THEN '>= 010'

END as groups

FROM (

SELECT from_address as swapper,

date_trunc('hour', block_timestamp) as hours,

count(DISTINCT tx_id) as n_swaps

FROM thorchain.swaps

WHERE block_timestamp >= CURRENT_DATE-60

GROUP by swapper,hours

)

WHERE groups is not NULL

GROUP by groups