date_trunc('day', block_timestamp) as days,

count(distinct tx_id) as trxs,

count(distinct tx_to) as users,

sum(amount) as volume,

case when block_timestamp::date <'2022-10-12' then 'before hack'

else 'after hack'

end as period

from solana.core.fact_transfers inner join solana.core.dim_labels

on tx_from = address

where label_type = 'cex'

and mint = 'So11111111111111111111111111111111111111112'

and block_timestamp::date >='2022-10-08'

group by 1, 2, 6