select case when block_timestamp::date >= '2022-12-24' then 'Holidays and New Year'
else 'Other' end as timespan,
project_name,
count (distinct tx_id) as TX_Count
from terra.core.fact_msgs t1 join terra.core.dim_address_labels t2 on t1.msg:attributes[0]:value = t2.address
where tx_succeeded = 'TRUE'
and block_timestamp >= '2022-12-01'
and msg:attributes[0]:key = 'recipient'
group by 1,2