SELECT COUNT(DISTINCT(TX_ID)) "Number of swaps", COUNT(DISTINCT(TRADER)) "Number of swappers",
CASE
WHEN BLOCK_TIMESTAMP::DATE BETWEEN '2023-01-07' AND '2023-01-13' THEN 'before the announcement of Station'
WHEN BLOCK_TIMESTAMP::DATE BETWEEN '2023-01-14' AND '2023-01-20' THEN 'after the announcement of Station'
END AS ANNOUNCEMENT
FROM terra.core.ez_swaps
WHERE BLOCK_TIMESTAMP::DATE BETWEEN '2023-01-07' AND '2023-01-20' AND TX_SUCCEEDED = TRUE
GROUP BY ANNOUNCEMENT