trunc(block_timestamp,'day') as date,

case when date <'2023-06-05' then 'Before SEC' else 'After SEC' end as period,

count(distinct tx_id) as transfers,

count(distinct tx_from) as senders,

count(distinct tx_to) as receivers,

sum(amount) as volume

from solana.core.fact_transfers

where mint='So11111111111111111111111111111111111111112'

and date>= '2023-05-20'

group by 1,2

order by 1