date_trunc('day', block_timestamp) as date,

case when block_timestamp::date = '2023-01-14' then 'Announcement Date'

when block_timestamp <= '2023-01-14' then 'Before Announcement Date'

when block_timestamp >= '2023-01-15' then 'After Announcement Date'

end as period,

count(tx_id) as no_of_txs,

count(distinct tx_sender) as no_of_users

from terra.core.fact_transactions

where block_timestamp >= '2023-01-01'

group by 1,2

order by 1