case when block_timestamp::date >= '2022-12-24' then 'Holidays and New Year'

else 'Other' end as timespan,

transfer_type,

count (distinct tx_id) as TX_Count,

count (distinct sender) as Senders_Count,

count (distinct receiver) as Receivers_Count

from terra.core.ez_transfers

where tx_succeeded = 'TRUE'

and block_timestamp >= '2022-12-01'

group by 1,2,3

order by 1