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,

COUNT(DISTINCT tx_hash) as transfers,

COUNT(DISTINCT origin_from_address) as users,

sum(amount_usd) as volume,

avg(amount_usd) as avg_transfer_size

FROM ethereum.core.ez_token_transfers

WHERE block_timestamp>=CURRENT_DATE-INTERVAL '1 MONTH'

and CONTRACT_ADDRESS = '0x4fabb145d64652a948d72533023f6e7a623c7c53'

GROUP BY 1 ,2 order by 1 asc