sum(amount) as volume, count(distinct tx_id) as "Transfer Count",

count(distinct tx_from) as "Sender", count(distinct tx_to) as "Receiver", case

when block_timestamp::date>'2023-06-05' then 'After'

when block_timestamp::date<'2023-06-05' then 'Before'

else 'SEC’s lawsuits announcement'

end as "Period"

from solana.core.fact_transfers

where mint='So11111111111111111111111111111111111111112'

and block_timestamp::date>='2023-05-20'

group by 1,6

order by 1