WITH claim AS (

SELECT

block_timestamp,

tx_hash,

to_address,

raw_amount/pow(10,18) AS amount

FROM bsc.core.fact_token_transfers

WHERE from_address = '0x26f5f3b28ecbbbfe64167df7c7a3590f90c90af9'

AND contract_address = '0xcc6f1e1b87cfcbe9221808d2d85c501aab0b5192'

AND block_timestamp::date >= '2024-01-29'

ORDER BY block_timestamp ASC

(CASE

WHEN amount < 50 THEN 'Less Than 50 Token'

WHEN amount >= 50 AND amount < 100 THEN 'Between 50 & 100 Token'

WHEN amount >= 100 AND amount < 500 THEN 'Between 100 & 500 Token'

WHEN amount >= 500 AND amount < 1000 THEN 'Between 500 & 1k Token'

WHEN amount >= 1000 AND amount < 1500 THEN 'Between 1k & 1.5k Token'

WHEN amount >= 1500 AND amount < 10000 THEN 'Between 1.5k & 10k Token'

WHEN amount >= 10000 THEN 'More Than 10K Token'

end) AS label,

count(DISTINCT to_address) AS users,

SUM(amount) AS token_amount

from claim

GROUP BY 1

ORDER BY 1 ASC