CASE

WHEN balance BETWEEN 1 AND 1000000 THEN '1-1,000,000 GUI'

WHEN balance BETWEEN 1000001 AND 10000000 THEN '1,000,001-10,000,000 GUI'

WHEN balance BETWEEN 10000001 AND 100000000 THEN '10,000,001-100,000,000 GUI'

WHEN balance BETWEEN 100000001 AND 500000000 THEN '100,000,001-500,000,000 GUI'

WHEN balance BETWEEN 500000001 AND 1000000000 THEN '500,000,001-1,000,000,000 GUI'

WHEN balance BETWEEN 1000000001 AND 5000000000 THEN '1,000,000,001-5,000,000,000 GUI'

WHEN balance BETWEEN 5000000001 AND 10000000000 THEN '5,000,000,001-10,000,000,000 GUI'

WHEN balance BETWEEN 10000000001 AND 50000000000 THEN '10,000,000,001-50,000,000,000 GUI'

ELSE '50,000,000,001+ GUI'

END AS volume_range,

COUNT(*) AS holder_count

FROM (

SELECT

account_address,

SUM(amount) AS balance

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

) AS holder_balances

GROUP BY

volume_range

ORDER BY

volume_range;