CASE

WHEN repeated_transactions BETWEEN 2 AND 5 THEN '2-5 Transactions'

WHEN repeated_transactions BETWEEN 6 AND 10 THEN '6-10 Transactions'

WHEN repeated_transactions BETWEEN 11 AND 20 THEN '11-20 Transactions'

WHEN repeated_transactions BETWEEN 21 AND 50 THEN '21-50 Transactions'

ELSE '51+ Transactions'

END AS transaction_range,

COUNT(*) AS account_count

FROM (

SELECT

account_address,

COUNT(*) AS repeated_transactions

FROM

aptos.core.fact_transfers AS et

JOIN

aptos.core.dim_tokens AS dt ON et.token_address = dt.token_address

WHERE

dt.symbol = 'GUI'

AND et.success = TRUE

AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)

GROUP BY

account_address

HAVING

COUNT(*) > 1

) AS repetitive_traders

GROUP BY

transaction_range

ORDER BY

transaction_range;