SELECT

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

pool_name,

count(DISTINCT tx_hash) as swaps,

sum(AMOUNT_IN_USD) as volume

FROM ethereum.core.ez_dex_swaps

WHERE (SYMBOL_IN='BUSD' or SYMBOL_OUT='BUSD') and AMOUNT_IN_USD is not null and amount_in_usd>1000000 and block_timestamp>=CURRENT_DATE-INTERVAL '1 MONTH'

GROUP BY 1,2 order by 1 asc