with t1 as (select 'Arbitrum' as network,
ORIGIN_FROM_ADDRESS as swapper,
count(distinct tx_hash) as n_swaps,
CASE WHEN n_swaps BETWEEN 1 AND 5 THEN '# swaps BETWEEN 1 AND 5'
WHEN n_swaps BETWEEN 5 AND 10 THEN '# swaps BETWEEN 5 AND 10'
WHEN n_swaps BETWEEN 10 AND 100 THEN '# swaps BETWEEN 10 AND 100'
ELSE ' # swaps is more than 100' END AS cat
from Arbitrum.core.fact_event_logs
where origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
and event_name = 'Swap'
and block_timestamp >= '2023-01-01'
group by 2)
SELECT
cat,
COUNT(swapper)
FROM t1
GROUP BY 1