select date_trunc (day,block_timestamp) as date,

case when block_timestamp::date < '2023-01-14' then 'Before Announcement'

else 'After Announcement' end as timespan,

transfer_type,

count (distinct tx_id) as TX_Count,

count (distinct sender) as Senders_Count,

count (distinct receiver) as Receivers_Count

from terra.core.ez_transfers

where tx_succeeded = 'TRUE'

and block_timestamp >= '2023-01-07'

group by 1,2,3)

select timespan,

avg (Tx_Count) as average_Tx_Count,

avg (senders_count) as Average_Senders_Count,

avg (receivers_count) as Average_Receivers_Count

from maintable

group by 1