when block_timestamp >= '2022-01-01' and block_timestamp < '2022-12-18' then 'other days'

when block_timestamp >= '2022-12-18' and block_timestamp <= '2023-01-03' then 'holidays'

end as time_frame,

COUNT(distinct tx_id) as tx_count,

count(distinct TX_SENDER) as uniqe_wallets

from terra.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and block_timestamp >= '2022-01-01' and block_timestamp <= '2023-01-03'

group by 1