SELECT

--date_trunc('day', block_timestamp) as week,

case when block_timestamp<'2023-02-13' then 'a. Before Paxos issue' else 'b. After Paxos issue' end as period,

CASE WHEN raw_amount/pow(10,18) < 100 THEN 'A. <$100'

WHEN raw_amount/pow(10,18) < 1000 THEN 'B. $100 - $1,000'

WHEN raw_amount/pow(10,18) < 10000 THEN 'C. 1,000 - $10,000'

WHEN raw_amount/pow(10,18) < 100000 THEN 'D. $10,000 - $100,000'

ELSE 'E. >$100,000' END as transfer_size,

count(DISTINCT tx_hash) as txs,

sum(raw_amount/pow(10,18)) as volume

FROM bsc.core.fact_token_transfers x

WHERE block_timestamp>=CURRENT_DATE-INTERVAL '1 MONTH' and contract_address=lower('0xe9e7CEA3DedcA5984780Bafc599bD69ADd087D56')

GROUP BY 1 ,2 order by 1 asc