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 amount_usd < 100 THEN 'A. <$100'

WHEN amount_usd < 1000 THEN 'B. $100 - $1,000'

WHEN amount_usd < 10000 THEN 'C. 1,000 - $10,000'

WHEN amount_usd < 100000 THEN 'D. $10,000 - $100,000'

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

count(DISTINCT tx_hash) as txs,

sum(amount_usd) as volume

FROM ethereum.core.ez_token_transfers

WHERE amount_usd is not null and symbol='BUSD' --and block_timestamp>=CURRENT_DATE-INTERVAL '3 MONTHS'

GROUP BY 1 ,2 order by 1 asc