date_trunc('day',block_timestamp) as date,

when date >= '2023-01-07' and date < '2023-01-14' then 'before announcement'

when date >= '2023-01-14' and date <= '2023-01-20' then 'after announcement'

end as time_frame,

count(distinct tx_id) as sell_tx,

count(distinct TRADER) as luna_seller,

sum(from_AMOUNT/pow(10,6)) as sell_amount,

sell_amount/luna_seller as "sell amount per user"

from terra.core.ez_swaps

where block_timestamp::date between '2023-01-07' and '2023-01-20'

and from_CURRENCY = 'uluna'

and TX_SUCCEEDED = 'TRUE'

group by 1,2