SELECT BLOCK_TIMESTAMP::DATE AS DAYS,SUM (AMOUNT)/1E6 AS AMOUNT_IN_LUNA,

CASE

WHEN DAYS BETWEEN '2023-01-07' AND '2023-01-13' THEN '1 week before the announcement of Station'

WHEN DAYS BETWEEN '2023-01-14' AND '2023-01-20' THEN '1 week after the announcement of Station'

END AS ANNOUNCEMENT

FROM terra.core.ez_transfers

WHERE CURRENCY = 'uluna' AND TX_SUCCEEDED = TRUE AND DAYS BETWEEN '2023-01-07' AND '2023-01-20' AND TRANSFER_TYPE = 'IBC_Transfer_In'

GROUP BY DAYS, ANNOUNCEMENT